<div>
try putting a application.displayalerts=<wbr />false to suppress any dialogs that may be invisible in the backgroud.<br />
You probably have an invisible over write alert!<br />
<br />

<pre><code id="code-20-40439645-1">    Application.DisplayAlerts = False

    wbOutput.Save
    wbOutput.SaveAs Filename:=strBackupPath, CreateBackup:=False, FileFormat:=xlOpenXMLWorkbook

     Application.DisplayAlerts = True</code></pre>
</div>


try putting a application.displayalerts=false to suppress any dialogs that may be invisible in the backgroud.
You probably have an invisible over write alert!



    Application.DisplayAlerts = False

    wbOutput.Save
    wbOutput.SaveAs Filename:=strBackupPath, CreateBackup:=False, FileFormat:=xlOpenXMLWorkbook

     Application.DisplayAlerts = True

<div>
Good shout ! It WAS saving it but in another folder. I'd unwittingly opened a copy of the workbook previously.<br />
Thanks for your help
</div>


Good shout ! It WAS saving it but in another folder. I'd unwittingly opened a copy of the workbook previously.
Thanks for your help

<div>
Thanks for your comments Glen. I had already set DisplayAlerts to False.
</div>


Thanks for your comments Glen. I had already set DisplayAlerts to False.

<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
In my Excel VBA application I'm trying to :<br />
<br />
1. Save the workbook.<br />
2. And then save the same workbook with a different name.<br />
<br />
My code looks like this....<br />
<br />
&nbsp; &nbsp;wbOutput.Save<br />
&nbsp; &nbsp;wbOutput.SaveAs Filename:=strBackupPath, CreateBackup:=False, FileFormat:=xlOpenXMLWorkb<wbr />ook<br />
<br />
It saves the workbook under its new name but it doesn't save the original workbook.<br />
<br />
Any ideas ?<br />
Thanks<br />
Toco
</div>
</div>


Hi All,

In my Excel VBA application I'm trying to :

1. Save the workbook.
2. And then save the same workbook with a different name.

My code looks like this....

   wbOutput.Save
   wbOutput.SaveAs Filename:=strBackupPath, CreateBackup:=False, FileFormat:=xlOpenXMLWorkbook

It saves the workbook under its new name but it doesn't save the original workbook.

Any ideas ?
Thanks
Toco

How can I Save a workbook in Excel VBA and then save it with a different name ?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.