Add and name a new workbook (not worksheet)

[Bagharmin]

I found plenty of posts regarding naming/renaming a worksheet, but I couldn't find one that addressed how to create and name a new workbook. I tried some very simple code:

Workbooks.Add
    ActiveWorkbook.Name = "Combined Data"

However, Excel tells me that Name is a read-only property of ActiveWorkbook. How do I just name my new workbook? I know I can do ActiveWorkbook.SaveAs and give it a filename, but I'm not at the point in my code where I want to do that.

All help is greatly appreciated.

 

[Datsmart]

As soon as you ADD a workbook, Excel gives it a name such as Book1, Book2, etc.
If you do not want to "give it a filename", what do you want to do?

 

[Bagharmin]

I don't want to save it (at least, not initially and maybe not at all), I just want to give the workbook a new name. Is there no way to do that without doing a SaveAs and specifying a filename?

 

[Datsmart]

No, you can not "give the workbook a new name" without using "SaveAs and specifying a filename".

 

[Bagharmin]

Ah, well. I shall live with it then.

Thanks for the help.