"Tom Ogilvy" wrote:

sPath = environ("temp") & "\"
activeworkbook.SaveAs sPath & "Myfile.xls"
' send the file
sName = Activeworkbook.Fullname
Activeworkbook.Close SaveChanges:=False
Kill sName

Awsome, thanks. I've always wondered how to do that...

Maury
Regards,
Tom Ogilvy



"Maury Markowitz" wrote:

"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