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

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

Anonymous — Fri, 03 Apr 2015 14:04:57 GMT

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.

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

avinashelite — Fri, 03 Apr 2015 15:03:43 GMT

set obj = ActiveDocument.GetSheetObject("CH703")

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

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

Anonymous — Tue, 07 Apr 2015 11:38:46 GMT

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

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

Anonymous — Tue, 07 Apr 2015 12:27:19 GMT

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