Results 1 to 1 of 1
Thread: Version control in a document
2012-07-17, 01:53 #1
- Join Date
- Jul 2012
- Thanked 0 Times in 0 Posts
Version control in a document
Hello good people,
Thanks mainly to Kim, I now have a document with some version control in it.
When created, the doc shows a userform with Title, Subject, Version and Change description.
The user changes the information, clicks OK and the system will open a SaveAs dialog.
The user selects the location and file name. The system appends "Version" and the version number to the file name and saves.
The next time the user wants to save the doc, a msgbox opens asking if a new Version is needed. If No, the doc is simply saved. If yes, the userform is opened again, user can change the version number and description.
In the document there is a Changes table. This table is updated with the current info and timestamped.
The document is then saved as a new document with the new version number in the file name.
OK, I will grant you, nothing Wow! about it, but for me it was a great joy to do, because:
- I needed the functionality
- I had never programmed in VBA
- I loved the help I have received
- I really enjoyed the challenge
Anyway, I have attached the file to the post, used it as much as you want.