Excel 2002 Automate shared workbook at close to save changes to new document
 

I have a report that I need others to add info into. Upon their closin
the workbook I'd like to have it automatically saved to a new workboo
with their changes, keeping my original workbook intact

--
tmerrifiel
-----------------------------------------------------------------------
tmerrifield's Profile: http://www.excelforum.com/member.php...fo&userid=1577
View this thread: http://www.excelforum.com/showthread.php?threadid=27282