Rename an open Excel Workbook without closing it
by
TheFreeWindows
·
August 2, 2020
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!
[sociallocker]
Download RenameOpenExcel macro
[/sociallocker]
Related Posts:
- Rename an active Word document without closing it
- Rename an active PowerPoint Presentation without closing it
- Split MS Excel datasets to separate workbooks or tabs, with Excel Explosion add-in
- Open Excel XLS XLSX spreadsheets and CSV, ODS files with Bytescout XLS Viewer
- Prevent UltraEdit from auto closing your tags
- Batch rename even via tags or text files, with preview and undo, using Rename Master
- Rename files and folders, even with profiles and with undo, using Bulk Rename Utility
- Add 67 new worksheet functions to Excel, with Morefunc
- Split MS Access datasets to separate tables or Excel tabs, with DataPig Access Explosion addin
- Improve Excel charts, even removing 3D styles, with Clean Charts
- Download free official Microsoft Excel Viewer
- Enjoy advanced Search and Replace in MS Excel with Regular Expression Find add-on
Tags: Excel MacrosMicrosoft ExcelMs Excelms office