Is there a way to do the following:

Upon closing an Excel file, I want the following to occour:
File, Save As (to a specific location, let's say H:\Template), Name the file
with the information in a certain cell (C17) and the current date, then close
the file.
Is this possible, and if it is could someone please help?

Thanks in advance!

Hi pt_lily

You can use SaveCopyAs to save the file to another location in the beforesave event
ThisWorkbook.SaveCopyAs "H:\Template\test.xls"

See Chip's site about events
http://www.cpearson.com/excel/events.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"pt_lily" wrote in message ...
Is there a way to do the following:

Upon closing an Excel file, I want the following to occour:
File, Save As (to a specific location, let's say H:\Template), Name the file
with the information in a certain cell (C17) and the current date, then close
the file.
Is this possible, and if it is could someone please help?

Thanks in advance!