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
