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