I am trying to get my workbook to export or save a single worksheet as
new file each time the main workbook closes . . . is this possible?
am trying to date and time stamp each newly created file as well so
can have a history of changes made on that one sheet . . . the reason
am doing this is because the workshhet is updated weekly and I woul
like to keep the past data on record instead of it being deleted eac
time someone types in a cell . . . I'm sure there is some simple cod
to do this that I am not understanding . . . thanks in advance for an
help on this matter

--
MD
-----------------------------------------------------------------------
MDC's Profile: http://www.excelforum.com/member.php...fo&userid=3439
View this thread: http://www.excelforum.com/showthread.php?threadid=54171