Setting Workbook Name by VBA
I'm adding Workbooks via VBA and want to assign a specific Workbook name (to
simplify for the user to identify the different workbooks). But the Workbook Object "Name" is Read Only so I can't change the default name. Any idea how to solve the problem? Thanks & regards, Reinhard |
Setting Workbook Name by VBA
Reinhard,
The name of a new workbook is assigned when it is created (e.g., Book1), and can be changed only by doing a SaveAs. That is to say, the name of a workbook is the file name of the workbook. If you want to change the name of a workbook, you must do a SaveAs. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Reinhard F. Bentrup" wrote in message ... I'm adding Workbooks via VBA and want to assign a specific Workbook name (to simplify for the user to identify the different workbooks). But the Workbook Object "Name" is Read Only so I can't change the default name. Any idea how to solve the problem? Thanks & regards, Reinhard |
All times are GMT +1. The time now is 09:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com