| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Refresh pivot table in workbook A when changing a cell in workbook | Excel Worksheet Functions | |||
| Changing default fie for backup saving | Excel Discussion (Misc queries) | |||
| Changing & Saving Fonts | New Users to Excel | |||
| Color Changes When Saving 2007 Workbook as 97 - 2003 Workbook | Excel Discussion (Misc queries) | |||
| Saving a Workbook: Forcing User to Rename before Saving | Excel Programming | |||
Linear Mode
