Say I have an excel file, "File1.xlsm". I want a VBA code, upon closure of the file, that will change the file name to "File1Ver2.xlsm". However, I don't want it to save a duplicate copy of the file under the old name. Anytime you "saveas" with a new name, it creates a new file, but leaves the old file under the old name. I want to change the name of the file without creating the duplicate with the old name. Hope this is clear.