title: Delete all Macros/vba when save as xls workbook
body: <p>I am using a procedure that creates a file and copies my workbook (xlsm) and saves as a xls workbook to the created file, and this is working well.</p>
  
  <p>I need to remove all Macros and vba when the <strong>save as</strong> is exacuted, i.e I need to remove the Macros/vba from the workbook being saved NOT the original workbook.</p>
  
  <p>I know I could save it as a xlsx workbook to remove all Macros and vba but I need the workbook to be a Macro/vba free xls workbook.</p>
  
  <p>I have Google'ed but did not find anything I could use, will continue to look and post back if I get this figured out.</p>