VBA - Save with New Filename
Hi,
I have written some code and at the end I want my workbook to be saved with
an altered name, and then close the workbook.
i.e. the macro has finished running on previously saved file named "Test
File 2.xls", i want the end of my macro to call this file "Test File 2 -
altered.xls", and save it in the same location as the original file and then
close the workbook.
Any suggestions?
Thanks,
|