1 Reply Latest reply: Jul 23, 2014 12:56 PM by Andres Quinteiro RSS

    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!!