Qlik Community

Community Corner

Discussion board for questions on how to use Qlik Community and its features.

Announcements
This forum is for questions and information about how to use the Qlik Community.
Please do not post product related questions here.
Select the correct forum from: Qlik Product Forums
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

Re: Convert workbooks to .xlsx format from macro

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

Community Browser