title: Excel VBA: SaveCopyAs with different file extenstion
body: <p>I have an Excel file with .xlsb extenstion and use its macros to generate several other Excel sheets based on the contents. The macros work in a way that they change the original Excel file and then use the <code>SaveCopyAs</code> method to save the generated Excel sheets. </p>
  
  <p>The generated Excel sheets should be saved with .xlsx extension and format.</p>
  
  <p>Using the <a href="https://msdn.microsoft.com/en-us/library/bb178003(v=office.12).aspx" rel="nofollow noreferrer">ActiveWorkbook.SaveCopyAs</a> "C:\TEMP\XXXX.XLSX" method is not working for me because while it does change the extension it does NOT change the file format so when a user opens a generated Excel file he receives a warning message (something like "the file extension and format does not match"). The <code>SaveCopyAs</code> method does not have any other arguments.</p>
  
  <p>How can I save the copies of my original .xlsb file with both the extension and format to be changed to .xlsx?</p>
  
  <p>Note: the <a href="https://msdn.microsoft.com/en-us/library/bb214129(v=office.12).aspx" rel="nofollow noreferrer">Workbook.SaveAs</a> method does have a <code>fileformat</code> option, not sure if that helps / relevant.</p>