Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

How to export pivot table object to excel and save it to a path automatically?

I have a pivot table object CH117. I need a button with macro which can export this object to excel and save this to my D:\Reports folder automatically... Your help is greatly appreciated.

Tags (1)
1 Solution

Accepted Solutions
Highlighted

Re: How to export pivot table object to excel and save it to a path automatically?

set obj = ActiveDocument.GetSheetObject("CH703")

obj.ExportEx "E:\Qlikview\Department_Loadinng.xls",

View solution in original post

3 Replies
Highlighted

Re: How to export pivot table object to excel and save it to a path automatically?

set obj = ActiveDocument.GetSheetObject("CH703")

obj.ExportEx "E:\Qlikview\Department_Loadinng.xls",

View solution in original post

Highlighted
Creator
Creator

Re: How to export pivot table object to excel and save it to a path automatically?

Thanks. It is working. Is there any way to save this excel file with auto filter enabled for the first row?

Highlighted
Creator
Creator

Re: How to export pivot table object to excel and save it to a path automatically?

Friends I found the solution for that too.

Function EnableAutoFilter()

Set objExcel = CreateObject("Excel.Application")

with objExcel.Workbooks.Open("D:\QlikView Reports.xls")

   .worksheets(1).Range("A1:Z23").Autofilter

   .save

   .close

end with

Set objExcel = Nothing

End Function