I need help writing a macro that upon closing excel (current file name =
file1.xl) would prompt the user to "enter changes made", and then the
macro would add this text along with the name of the person who entered
the change, to a page in excel and save the file as file2.xl.

This way I could keep track of the changes made, as well as have
different file names to go back to previous work.

Is this possible in VBA? If so could someone point me in the right
direction.


--
mattflow
------------------------------------------------------------------------
mattflow's Profile: http://www.excelforum.com/member.php...o&userid=25129
View this thread: http://www.excelforum.com/showthread...hreadid=542664

Any thoughts?


--
mattflow
------------------------------------------------------------------------
mattflow's Profile: http://www.excelforum.com/member.php...o&userid=25129
View this thread: http://www.excelforum.com/showthread...hreadid=542664

With regard to version control, the best method I've found is to increment a
counter in the filename.

MySheet v0.1.xls
MySheet v0.2.xls

You also might export and archive your modules, but I haven't spent the time
to try to automate the process yet.

Best regards,
Greg

"mattflow" wrote in
message ...

Any thoughts?


--
mattflow
------------------------------------------------------------------------
mattflow's Profile:
http://www.excelforum.com/member.php...o&userid=25129
View this thread: http://www.excelforum.com/showthread...hreadid=542664