? environ("temp")
C:\DOCUME~1\OgilvyTW\LOCALS~1\Temp

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

--
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