How to Batch Convert Excel 2003 to Excel 2010- .xls to .xlsx or .xlsm (macro and utilities) (Excel Training)

How to Batch Convert Excel 2003 to Excel 2010- .xls to .xlsx or .xlsm

If you’d like to convert just 1 document from an .xls to .xlsx.

Just choose
File > Convert

If you’d like to batch process many files you can use this macro or see

Sub ConvertToXlsb()
   Dim strPath As String
   Dim strFile, strConvFile As String
   Dim wbk As Workbook
   Dim i As Integer
   Dim Dun As Boolean

   i = 0
   Dun = False

   Do Until Dun
      i = i + 1
      If ThisWorkbook.Worksheets(1).Cells(i, 1) <> "" Then
         ' Path must end in trailing backslash
         ' IE C:\Test\
         strPath = ThisWorkbook.Worksheets(1).Cells(i, 1).Value
         strFile = Dir(strPath & "*.xlsx")
         Do While strFile <> ""
            If Right(strFile, 4) = "xlsx" Then
               Set wbk = Workbooks.Open(Filename:=strPath & strFile)
               strConvFile = Replace(strFile, "xlsx", "xlsb")
               wbk.SaveAs Filename:=strPath & strConvFile, FileFormat:=xlExcel12
               wbk.Close SaveChanges:=False
            End If
            strFile = Dir
         Loop
      Else
         Dun = True
      End If
   Loop
End Sub

There are paid and trial software to do this if you are basic.

PC

http://www.systoolsgroup.com/upgrade-excel-2003-to-2010.html

$49

Mac
http://www.excelentsoftware.com/excel_converter.html
$20

One thought on “How to Batch Convert Excel 2003 to Excel 2010- .xls to .xlsx or .xlsm (macro and utilities) (Excel Training)

Leave a Reply

Your email address will not be published. Required fields are marked *

* Copy This Password *

* Type Or Paste Password Here *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>