title: Save a copy of an excel workbook without macro
body: <p>I have an Excel 2010 template file with macros that includes the following code:</p>
  
  <pre><code>    ActiveWorkbook.SaveAs Filename:= _
      newname, FileFormat:= _
      51, CreateBackup:=False
  </code></pre>
  
  <p>This saves the current workbook as a non-Macro enabled workbook, but then I obviously cannot run the rest of the macros that I need.</p>
  
  <p>I tried to use</p>
  
  <pre><code>    ActiveWorkbook.SaveCopyAs Filename:= _
      newname, FileFormat:= _
      51, CreateBackup:=False
  </code></pre>
  
  <p>This yields a syntax error.  My goal is to save a copy with the new name, so the template file remains unchanged and can be run daily.</p>