Thread: Changing the name of a workbook without saving it
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Maury Markowitz Maury Markowitz is offline
external usenet poster
  
Posts: 86
Default Changing the name of a workbook without saving it
The dox state that the .Name propery is read/write, but when I try to...

ActiveWorkbook.Name = "MyBook"

I get an error stating it's read-only. Sigh.

Is there any way to name the book without saving? I'm creating the book to
be e-mailed as an attachment, that part works but it goes out as "Book1" or
whatever.

Maury
Reply With QuoteReply With Quote