Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Naming a workbook WITHOUT saving it?
I use Excel to make workbooks up from inside Access, then call Excel's
Outlook integration to send it: oExcelApp.ActiveWorkbook.SendMail Recipients:=Array(... However, this sends out the book with the default name, like "Book 1" and such. Is there some way to change the name of the book without saving it? This obvious solution does NOT work: oExcelApp.ActiveWorkbook.Name = "New name" If there is no way to do this without saving, where is a good "temp" location to save it to? Maury |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Naming a workbook WITHOUT saving it?
"Tom Ogilvy" wrote:
No, you must save it to name it. However after sending it you could Kill it kill "C:\Temp\Mybooks.xls" Fair enough! Is \temp\ always available on C? Maury |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel 2003, how do I automate file naming/saving + date? | Setting up and Configuration of Excel | |||
Naming a workbook WITHOUT saving it? | Excel Programming | |||
Naming a workbook WITHOUT saving it? | Excel Programming | |||
Workbook naming | Excel Programming | |||
Saving a Workbook: Forcing User to Rename before Saving | Excel Programming |