View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Changing the name of a workbook without saving it

Hi

You must save it, but you can delete it after that.

Try this
http://www.rondebruin.nl/mail/folder1/mail1.htm
Example 2

Or with Outlook
http://www.rondebruin.nl/mail/folder2/mail1.htm


Or use my Add-in
http://www.rondebruin.nl/mail/add-in.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Maury Markowitz" wrote in message
...
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