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 ?