Keeping track of changes and saves

[mattflow]

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]

Any thoughts?

 

[Gregory Kip]

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