Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
Qlikview supoorts format .xlsx? Because converts only to .xls with this macro.