Naming a workbook WITHOUT saving it?

[Maury Markowitz]

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

[Maury Markowitz]

"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