Tocogroup
asked on
How can I Save a workbook in Excel VBA and then save it with a different name ?
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:=xlOpenXMLWorkb ook
It saves the workbook under its new name but it doesn't save the original workbook.
Any ideas ?
Thanks
Toco
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:=xlOpenXMLWorkb
It saves the workbook under its new name but it doesn't save the original workbook.
Any ideas ?
Thanks
Toco
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Good shout ! It WAS saving it but in another folder. I'd unwittingly opened a copy of the workbook previously.
Thanks for your help
Thanks for your help
ASKER
Thanks for your comments Glen. I had already set DisplayAlerts to False.
You probably have an invisible over write alert!
Open in new window