Discussion Board for collaboration related to QlikView App Development.
Hi I have an application, where 2 Straight Table. I want to export the both straight table data in Single Excel but in sheet1 and Sheet 2.
Macro is working but it is not exporting CH01 object data, In both sheet CH02 data is coming.
Below is my code :
DIM ExcelApplication, ExcelWorkbook
SET ExcelApplication = CREATEOBJECT("Excel.Application")
SET ExcelWorkbook = ExcelApplication.Workbooks.AddSET MyExcelApp = NothingActiveDocument.GetSheetObject("CH01").CopyTableToClipBoard TRUEActiveDocument.GetSheetObject("CH02").CopyTableToClipBoard TRUE
ExcelApplication.DisplayAlerts = FALSE
MsgBox "Export Complete"
I am also attaching my QVW.
Please do the needful. Thanks in advance.