How can I Save a workbook in Excel VBA and then save it with a different name ?
Posted on 2014-11-13
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.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 ?