Rename an open Excel Workbook without closing it
by
·
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!
Download RenameOpenExcel macro
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
- Rename files and folders, even with profiles and with undo, using Bulk Rename Utility
- Batch rename even via tags or text files, with preview and undo, using Rename Master
- Prevent UltraEdit from auto closing your tags
- Add 67 new worksheet functions to Excel, with Morefunc
- Improve Excel charts, even removing 3D styles, with Clean Charts
- Enjoy advanced Search and Replace in MS Excel with Regular Expression Find add-on
- Compare Microsoft Excel spreadsheets easily, with Spreadsheet Compare add-in
- Use regular expressions to search and replace in Excel, with Regular Expression Find add-on
Tags: Excel MacrosMicrosoft ExcelMs Excelms office
