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!