? 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