Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! 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.