Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook renaming
I want to rename a workbook as soon as it’s loaded. In th
ThisWorkBook_Open event I tried: Workbook.Name = “MyName.xls” but that doesn’t work because WorkBook’s Name property is read-only. then used a SaveAs routine using the new name. That works because th workbook then assumes the name used in SaveAs, but saving the fil takes too long. How can I rename a workbook while it’s loaded othe than doing a “SaveAs”? Any help greatly appreciated -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook renaming! | Excel Programming | |||
Renaming workbook! | Excel Programming | |||
Workbook crashes after renaming a worksheet - References problem? | Excel Programming | |||
Excel VBA: Renaming a workbook | Excel Programming | |||
Renaming Sheets in a workbook | Excel Programming |