SaveCopyAs does not require that the workbook be saved.


"witek" wrote in message
...
SaveCopyAs creates a copy and doesn't save current workbook.
Problem is that current workbook must be saved, not simply its
copy created. Why? Because of bug in Excel.




NickHK wrote:
witek,
.SaveCopyAs ?

NickHK

"witek" wrote in message
...

opened workbook, doesn't mean that I can write any code to it.

1.
Workbook is created from VBA code from scratch, but VBA code
is in

add-in.

For some reasons this newly created workbook must be saved.
After that if user saves it, it is saved under the temporary
name chosen
by me.
I don't want to and I can't force Save As option.
I would like to have it as a noname even if I saved it before.

2. if user saved using his own name, he needs option to leave
it open as
a noname, so next time choosing File/Save Excel will ask for
a name.

What I need is option like ActiveWorkbook.FullName = ""

Is it clear now?




Tom Ogilvy wrote:

I have an opened workbook which was saved by a user.

was your original problem statement. You have now
contradicted that.

If you determine what your actual situation is, then
certainly, post

back.

If a workbook has been saved, then it will have a name.
Possibly you

are

looking for a template.