Saving File with New Name
There is an Excel file that teaches how to perform the Saving File with New Name operation.
Excel Powered Saving File with New Name
This workbook demonstrates saving file with new name using VBA macros on a 15-row data layout.
Hope it is useful.