Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting up a workbook | Setting up and Configuration of Excel | |||
Setting up protection on a workbook | Excel Worksheet Functions | |||
how can i remove workbook protection setting??? | Excel Discussion (Misc queries) | |||
Setting Up Workbook Permissions | Excel Programming | |||
Setting values in another workbook | Excel Programming |