Save over file with new name but delete the old one

**yohanmcdonald** · 02-03-2015, 12:22 PM

I am looking for help creating a commandbutton that, when clicked, saves the current file with a new name. I already have this part done but I have to go back into the file folder and delete the old version of the file. I am hoping it is possible to do this while it saves the new version of the file.

Please Login or Register  to view this content.

Cell P46 is a cell that groups other cells together to get a specific name. After a person selects a checkbox it adds 1 of a possible 3 different suffixes onto the filename and saves it. The way it is set up now I will end up with 4 files in the same folder that are just the same thing only updated. I want it to delete all older versions of the file whenever it updates.

**6StringJazzer** · 02-03-2015, 01:24 PM

This code is more complex than necessary to do what you describe. It isn't necessary to change all those Application attributes to be able to save a file; the action won't trigger alerts, screen updating, calculation, or events. Also I don't see why you show the user a dialog box to save the file when you already know what name you want to use. That will allow the user to save it with any name, in any folder. If that's what you intend to do, you can use your original line of code for that.

I would suggest the following, which I have tested:

Please Login or Register  to view this content.

I just gave this a second thought--do you have a BeforeSave or AfterSave event handler? In that case you may want to turn off events, but it all depends on what the handler does and whether you want to disable it for this particular save.

**yohanmcdonald** · 02-03-2015, 05:21 PM

This code works perfectly and I think most of my coding has redundant lines in it. I am new to this stuff and I think I should probably start asking for more help. Thank you so much!