Hi Migle / Youssef - I don't have this setup - but I believe it is the same - just now supports .xlsx - in the past - it would create a .xlsx - but there would be an error opening the file. Can you give it a try using the extension .xlsx and let us know?
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.
but I believe it is the same - just now supports .xlsx - in the past - it would create a .xlsx - but there would be an error opening the file. Can you give it a try using the extension .xlsx and let us know?
The ExportBiff function still generates a document with the old .XLS format. I get the same result as migle.purzelyte. Is there maybe a new function available in the API to get the new .XLSX format as output?
We appreciate your help for this. We aren't the only one with this question.
This is how I do the export to xlsx in QV (november release).
set obj = ActiveDocument.GetSheetObject("CH1")
set objExcel = CreateObject("Excel.Application")
objExcel.Visible = False
Set ASheet = objExcel.ActiveSheet
ASheet.Application.DisplayAlerts = False