Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convert workbooks to .xlsx format from macro

Hi everybody! I have a macro to convert files to .xlsx format. The problem is that convert the files to .xls and not to .xlsx. The line is:

objExcel.ActiveWorkbook.SaveAs(CurrentDirectory & FileName), FileFormat= xlOpenXMLWorkbook

Thank you!!

1 Reply
Not applicable
Author

Qlikview supoorts format .xlsx? Because converts only to .xls with this macro.