Yes - any drive - any folder

ChDir "C:\temp"
s = ActiveWorkbook.Name
ActiveWorkbook.SaveAs Filename:="C:\temp\" & s

This uses the same name as the file you get.
--
Gary''s Student - gsnu200741


"Richard Champlin" wrote:

I take it I could use any drive & folder designation (rather than "C:\temp")?

Is it possible to specify a filename that reflects the filename in the
attachment worksheet I received?

Thanks!
--
Richard Champlin
Administrative Program Assistant II
Children''''''''s Hospital & Regional Medical Center, Seattle


"Gary''s Student" wrote:

Just include lines like:

ChDir "C:\temp"
ActiveWorkbook.SaveAs Filename:="C:\temp\Book1.xls"
--
Gary''s Student - gsnu200741


"Richard Champlin" wrote:

Once I have opened up a spreadsheet that I received in an e-mail, and
utilizing a macro to format it the way I want it, is it possible to then save
the worksheet in a particular location and with a standard name as the final
steps in the macro?
--
Richard Champlin
Administrative Program Assistant II
Children''''''''s Hospital & Regional Medical Center, Seattle