fixed save as name?
 

Is there anyway I can force an excel file to change to a
predetermined name upon closure?

SDC

fixed save as name?
 

Possibly use the workbook_Beforeclose event. Save the workbook in that
routine.

Look at Chip Pearson's site on events if you are not familiar with
programming events.
http://www.cpearson.com/excel/events.htm



--
Regards,
Tom Ogilvy

scrabtree23 wrote in message
...
Is there anyway I can force an excel file to change to a
predetermined name upon closure?

SDC