Rename an open Excel Workbook without closing it


If you like to change the name of your Excel Workbook without locating it in Windows Explorer, you can do it with this macro.

The macro lets you rename the Workbook you have currently open, without having to close it.

It pops up the Save As prompt, then it saves your Workbook with any name you decide, and deletes your old workbook.

Enjoy!

Leave a comment