title: SaveAs without prompt to save
body: <p>I have this excel macro with which I make a copy of a file (Newbook), change it and and save the original (Oldbook) under a new name. </p>
  
  <p>However, even though I'm using SaveAs, excel keeps giving me this prompt to confirm that I want to save the original file under the name that I gave it. </p>
  
  <p>I've already tried: </p>
  
  <ul>
  <li><p>Oldbook.Saved = True</p></li>
  <li><p>SaveChanges = True</p></li>
  <li><p>Application.DisplayAlerts = False</p></li>
  </ul>
  
  <p>None work. </p>
  
  <pre><code>    Application.DisplayAlerts = False
  
      Newbook.Save
      Newbook.Close
  
      Oldbook.SaveAs Filename:=fNameOld, FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
      ReadOnlyRecommended:=False, CreateBackup:=False
  
      Oldbook.Close
  
      Application.DisplayAlerts = True
  </code></pre>
  
  <p>Any ideas?</p>