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
Qlikview supoorts format .xlsx? Because converts only to .xls with this macro.
Retrieving data ...