title: Batch convert .xls to .xlsx with VBA without opening the workbooks
body: <p>I have a bunch of Excel-Workbooks in the old <code>.xls</code> format. I'd like to convert them to <code>.xlsx</code> using VBA. The following code accomplishes this task but it needs to open each workbook in order to save it again.</p>
  
  <pre><code>Dim wbk As Workbook
  Set wbk = Workbooks.Open(filename:="C:\some\example\path\workbook.xls")
  wbk.SaveAs filename:="C:\some\example\path\workbook.xlsx", _
  FileFormat:=xlOpenXMLWorkbook, AccessMode:=xlExclusive, ConflictResolution:=Excel.XlSaveConflictResolution.xlLocalSessionChanges
  wbk.Close SaveChanges:=False
  </code></pre>
  
  <p>Is there another way to do this task without the need to open each workbook?
  This is very time consuming with at least 30-100 workbooks.</p>