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

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