Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Export to Excel / CSV as multiple files

Capture.PNG

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.?

4 Replies
robert_mika
Master III
Master III

Look here for some ideas:

www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/

Anonymous
Not applicable
Author

Thanks Rob, Let me try and will get back to you. it is a nice link.

Anonymous
Not applicable
Author

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)

Anonymous
Not applicable
Author

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)