Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Friends,
I have a pivot table chart object as above. When I export to this to excel. I am able to get the export as one file. Is there any way to use a macro or something to perform a click which will split this to 3 files based on the Country and save it to a location.?
Look here for some ideas:
www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/
Thanks Rob, Let me try and will get back to you. it is a nice link.
Hi Rob
I am getting error like below. What should I do.
My object ID is 25 so I tried below and when tried to run the macro...
Error: Type mismatch: 'copyObjectsToExcelSheet'
Code used:
Dim aryExport(25,3)
aryExport(25,0) = "objSalesPerYearAndRegion"
aryExport(25,1) = "Sales"
aryExport(25,2) = "A1"
aryExport(25,3) = "data"
Dim objExcelWorkbook 'as Excel.Workbook
Set objExcelWorkbook = copyObjectsToExcelSheet(ActiveDocument, aryExport)
Hi Rob
I am getting error like below. What should I do.
My object ID is 25 so I tried below and when tried to run the macro...
Error: Type mismatch: 'copyObjectsToExcelSheet'
Code used:
Dim aryExport(25,3)
aryExport(25,0) = "objSalesPerYearAndRegion"
aryExport(25,1) = "Sales"
aryExport(25,2) = "A1"
aryExport(25,3) = "data"
Dim objExcelWorkbook 'as Excel.Workbook
Set objExcelWorkbook = copyObjectsToExcelSheet(ActiveDocument, aryExport)