Thread: Changing the name of a workbook without saving it
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
chijanzen chijanzen is offline
external usenet poster
  
Posts: 139
Default Changing the name of a workbook without saving it
Try it

ActiveWorkbook.SaveAs Filename:="C:\MyBook"

--
http://www.vba.com.tw/plog/


"Maury Markowitz" wrote:

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