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!
.