VBA - Save with new filename
Hi,
I have a macro which runs lots of changes on an excel file, the one thing i
am unsure on how to do is to get the end of the macro to save the file with
an altered name in the same location as the original file, then close the
workbook.
e.g.
The file is named "Test File 2.xls", and I want it to be called "Test File 2
- altered.xls", to be saved in the same location as the original file, then
for the workbook to close.
Any suggestions?
Thanks,
|