Discussion board where members can get started with QlikView.
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.
set obj = ActiveDocument.GetSheetObject("CH703")
View solution in original post
Thanks. It is working. Is there any way to save this excel file with auto filter enabled for the first row?
Friends I found the solution for that too.
Set objExcel = CreateObject("Excel.Application")
with objExcel.Workbooks.Open("D:\QlikView Reports.xls")
Set objExcel = Nothing