S scrabtree23 Oct 5, 2003 #1 Is there anyway I can force an excel file to change to a predetermined name upon closure? SDC
T Tom Ogilvy Oct 5, 2003 #2 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
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
