How to simultaneously rename a file in MS Office and delete old version?

Question

In Microsoft Office, when wanting to save a file to a different file name without keeping a copy of the previous file name, doing so requires two steps: - First, File -> Save As... and select the new name. A *copy* of the file is made. - Then, go into Windows Explorer and delete the old file with the old name.I would like to simplify these steps by "renaming" the file, from Office itself, in one step. How could I do this?*For a more entertaining and cryptic version see [Revision 1](https://superuser.com/revisions/591143/1).*

Answer 1

Instead of doing the save as, you can just go to your documents folder, find the document that you are looking for, right click it and click on rename.

Answer 2

Offhand, I'm not sure this is doable using only an Excel macro. However, it is possible if you can create VBA code, since you can invoke VBA code from Excel. Here's a couple of links that could suggest some possabilities:

https://analysistabs.com/excel-vba/delete-files-folder/

https://www.excel-easy.com/vba/examples/run-code-from-a-module.html