no argument

However I cannot see any point in this exercise. A user can save a workbook
with any name, and you can write code to do so too ... you agreed
already --- so why bother saving as a template and then reopening the
template wich by default will have 1 added , when its really not necessary.

no worries. if you're happy, then fine

please close this thread.



"Yar Glazkov" wrote in message
...
Patrick, I really do not understand - do you argue me?
If so, what point you do not agree with:
- That way described does not produce workbook with (almost) arbitrary
name without saving this workbook?
- That this way is optimal?

If you do not, what the last post is about?

"Patrick Molloy" wrote:

A workbook, when opened , already has a name
Yes, sure!

A new workbook, when created, will have a default name based off the
template with number appended. that way, more than one new workbook can
be
created.
Of course!

The workbook's name won't change until the workbook is saved ...
Hell, yes!

and either
that can be coded into the VBA or left to the user.
I swear it can be done!

But all this I do not object... I describe way how to use theese facts for
creating workbook with name, other than book1 or <templatename1 if from
template.

Please, if this way is not optimal, tell about more optimal one.
Please, remember about restriction: no created files left after moment
when
users gets control over newly created workbook.

I'll describe the solution shortest way I can, again :-)
Create empty workbook, save it as template with arbitrary name, close
workbook, create workbook from this newly created template, delete
template