I am copying a worksheet into a new workbook. Is there a
way to name this new workbook something other
than "Book1" without saving it?

Thanks,
-TT

Tommy,

I don't think so, Name is a read-only property.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Tommy T" wrote in message
...
I am copying a worksheet into a new workbook. Is there a
way to name this new workbook something other
than "Book1" without saving it?

Thanks,
-TT

Upon completion of the copy, the active workbook is normally the target
workbook. Whatever it was called, you can rename it anything you want
without knowing it current name:

strTempName = ActiveWorkBook.Name

WorkBook(strTempName).Name = "whatever you want"


---
Message posted from http://www.ExcelForum.com/

For the benefit of the OP,
This information is incorrect.

--
Regards,
Tom Ogilvy

MWE wrote in message
...
Upon completion of the copy, the active workbook is normally the target
workbook. Whatever it was called, you can rename it anything you want
without knowing it current name:

strTempName = ActiveWorkBook.Name

WorkBook(strTempName).Name = "whatever you want"


---
Message posted from http://www.ExcelForum.com/

My apologies to the forum. I thought I had actually done what I
previously mentioned several times. But what I actually did is what
another suggested, i.e., save the active workbook with the particular
name right after creating it.


---
Message posted from http://www.ExcelForum.com/

No, the name of the workbook is its saved file name (the exception being
Book#). You can not change that default name except by saving the workbook.
(You could always kill it after you are through with it).

--
Regards,
Tom Ogilvy

Tommy T wrote in message
...
I am copying a worksheet into a new workbook. Is there a
way to name this new workbook something other
than "Book1" without saving it?

Thanks,
-TT