Add suffix to existing filename

[delaing]

I am needing code to save an existing workbook while adding a suffix to the existing filename.

i.e. "workbook.xls" becomes "workbook reviewed.xls"

Also, if the routine can do it regardless of the existing extension; may be xls, xlsx, or xlsm, that would be helpful.

Thank you,
Delain

[Kenneth Hobson]

This should get you nearly there. Concatenate the strings to build your filename and replace it and the file type from a recorded File > SaveAs macro.

Please Login or Register  to view this content.

[jolivanes]

Another way if it is for the workbook you are in.
Saves the workbook in the same folder with the new name.

Please Login or Register  to view this content.