Hi Jan Eric,

A workbook's name is created when the workbook is saved, so this is not
possible.

The default new workbook name (usually "Book" and a numeric) can be altered
by changing (and saving) the (xlt) template file.

What is it that you are attempting to do and why do you find it necessary,
or desirable, to assign a name without saving the workbook?

---
Regards,
Norman



"Jan Eric Nilsson" wrote in message
...
Is it possible through VBA to create a new Workbook and also assign a
given name to the Workbook without having the Workbook saved?

Best Regards

Jan Eric