| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
default name for a new book
Hello, My macro creates a new book. This new book comes automatically with a default "book#". I would like to change automatically this name without saving the file on the harddisk or without opening the dialog book "save" or "save as". Can't find the command. thanks for your help *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
default name for a new book
The workbook's name gets changed when you save it.
You could use a template when you create the new workbook and the name will look like "mytemplate#". gerard Genevois wrote: Hello, My macro creates a new book. This new book comes automatically with a default "book#". I would like to change automatically this name without saving the file on the harddisk or without opening the dialog book "save" or "save as". Can't find the command. thanks for your help *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
default name for a new book
I think this is what you are looking for:
Sub test() Workbooks.Add ActiveWindow.Caption = "My file" End Sub Abdul Salam -----Original Message----- Hello, My macro creates a new book. This new book comes automatically with a default "book#". I would like to change automatically this name without saving the file on the harddisk or without opening the dialog book "save" or "save as". Can't find the command. thanks for your help *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
default name for a new book
Tks for the reply. It changes the name of the caption..... but when you open save as or save.... it's still "book1" which appears.... *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Default Book Formatting | Excel Discussion (Misc queries) | |||
| Column widths reset to default when pasted into a new work book | Excel Discussion (Misc queries) | |||
| How to set printer default to select active sheet not whole book | Excel Discussion (Misc queries) | |||
| Book.xlt in doesn't open as default | Excel Discussion (Misc queries) | |||
| default template (book.xlt) doesn't close | Excel Discussion (Misc queries) | |||
Linear Mode
