Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
kvijay173
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.

1 Solution

Accepted Solutions
avinashelite

set obj = ActiveDocument.GetSheetObject("CH703")

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

View solution in original post

3 Replies
avinashelite

set obj = ActiveDocument.GetSheetObject("CH703")

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

View solution in original post

kvijay173
Creator
Creator
Author

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

kvijay173
Creator
Creator
Author

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