B
billyb
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
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