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

    Convert workbooks to .xlsx format from macro

    Andres Quinteiro

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