Discussion Board for collaboration related to Creating Analytics for QlikView.
I have the ffg macro that exports two pivot tables and works :
set XLApp = CreateObject("Excel.Application")
XLApp.Visible = FALSE
set XLDoc = XLApp.Workbooks.Add
XLDoc.Sheets(1).name = "By FundCode"
set XLSheet = XLDoc.Worksheets(1)
set MyTable = ActiveDocument.GetSheetObject("CH05")
set MyTable = ActiveDocument.GetSheetObject("CH04")
XLApp.Visible = False
Set XLApp = Nothing
Set Table = Nothing
I am also trying to export 2 more pivot tables into the same excel workbook but into different sheets, I have tried for hours to crack this but can't seem to get it right....
Any help will be appreciated...