Name of a new workbook

  • Thread starter Thread starter Tommy T
  • Start date Start date
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
 
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)
 
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"
 
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).
 
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.
 
Back
Top