Name of a new workbook

T

Tommy T

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
 
B

Bob Phillips

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)
 
M

MWE

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"
 
T

Tom Ogilvy

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).
 
M

MWE

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.
 
Top