Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
sona_sa
Creator II
Creator II

Re : Export Pivot Table Data to XLS

I have two pivot table.

I am able to export data in xls, but in different xls. But I want both pivot table data should to go in single xls but in different - different sheet. One Pivot Table Data in Sheet1 and another Pivot Table Data in Sheet2. Below is my code. Working properly. I want one excel file in sheet 1 and sheet 2 instead of two excel file.

Sub ExportExcel

set obj = ActiveDocument.GetSheetObject("CH01")
set obj = ActiveDocument.GetSheetObject("CH03")
obj.ExportBiff "E:\WTL WORK\ESCORTS\CH01.xls"
obj.ExportBiff "E:\WTL WORK\ESCORTS\CH03.xls"

End sub

Please look into it and let me know any idea. Thanks in advance.

Regards 

AI

Labels (1)
1 Reply
sona_sa
Creator II
Creator II
Author

Can anyone help me on this ?

I have two pivot table.

I am able to export data in xls, but in different xls. But I want both pivot table data should to go in single xls but in different - different sheet. One Pivot Table Data in Sheet1 and another Pivot Table Data in Sheet2. Below is my code. Working properly. I want one excel file in sheet 1 and sheet 2 instead of two excel file.

Sub ExportExcel

set obj = ActiveDocument.GetSheetObject("CH01")
set obj = ActiveDocument.GetSheetObject("CH03")
obj.ExportBiff "E:\WTL WORK\ESCORTS\CH01.xls"
obj.ExportBiff "E:\WTL WORK\ESCORTS\CH03.xls"

End sub

Please look into it and let me know any idea. Thanks in advance.

Regards 

AI