Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ashok1203
Creator II
Creator II

Export Qlikview object to .xlsx format on PostReload

Hi, 

I am able to export the same with .xls format by using the ExportBiff keyword in Macro. But, i want to export it to .xlsx format in Qlikview 12.0. 

If i am doing the same by using ExportBiff it was creating the file but in invalid format. 

Please reach out to me if anything disconnects. 

Thanks in Advance...!

 

Regards,

Ashok

AAK
Labels (6)
2 Replies
Frank_Hartmann
Master II
Master II

try like this:

 

Sub XLSX_Export
Filename = "Report"
set obj = ActiveDocument.GetSheetObject("CH01") 
set objExcel = CreateObject("Excel.Application")
objExcel.Visible = False
set xlDoc= objExcel.Workbooks.Add
Set ASheet = objExcel.ActiveSheet
ASheet.Application.DisplayAlerts = False
ASheet.Range("A1").Select
obj.CopyTableToClipboard true
ASheet.Paste
objExcel.DisplayAlerts = FALSE
ASheet.SaveAs "C:\Users\Admin\Desktop\"&Filename&".xlsx"
objExcel.Quit 
end Sub
ashok1203
Creator II
Creator II
Author

Hi, 

Thanks for the response. 

When i am trying to execute the macro it was throwing error on below line. 

set objExcel = CreateObject("Excel.Application")

Can you help me to get resolve, i am using QV12.0 SR5.

Regards,

Ashok

AAK