title: Workbook.SaveAs won't save without the VBA Code
body: <p>I have a macro-enabled workbook that I have to send out to others via email after the code is run. The problem is with the macros the workbook is to large to send. I have been manually saving a copy of the workbook as <code>.xlsx</code>. I'm now trying to do this automatically. </p>
  
  <p>My code to save is as follows:</p>
  
  <pre><code>Application.DisplayAlerts = False
  
  ActiveWorkbook.Save
  ActiveWorkbook.SaveAs Filename:="Workbook_No_Macros" 
  FileFormat=xlWorkbookNormal
  
  Application.DisplayAlerts = True
  </code></pre>
  
  <p>The problem is when I go and look at the one that is supposed to not have the VBA code is still too large because the code is being saved with the workbook even though it is being saved a workbook that is not macro-enabled. This also results in Excel seeing the file as corrupted and not wanting to open it outside of compatibility mode.</p>
  
  <p>Any ideas on how to save the workbook without the code embedded in it?</p>
  
  <p>Edit: I have also tried</p>
  
  <pre><code>FileFormat:=56
  </code></pre>