Updating Current Workbook with New Version Via Code?

You can have a shared location have an excel file that is locked (so they cant update it) that houses ONE cell, the latest version of the workbook. Then if the latest version is greater than their version it forces them to either contact you for the update patch/macro or it can direct the user to the correct update in that same shared location.

This assumes all users have access to that location.

I had to implement something like this when I had 40 people on the team using different versions and complaining that things didn't work as they should. I just passed out an update macro to either replace their current workbook OR update the new workbook with data from the old workbook etc etc.


It's a huge pain honestly, so I just had a quick check when the workbook opened to see if they had the latest version otherwise it would throw up a message box to contact me for the update. This let them know they were potentially at risk, and if they didnt need to do any work in the file, they could still use it to view data or something.



Also, since I forced them to save their current versions on the shared drive, I used ADO to quickly rip the version number out of all the books so I could always tell if someone was on an old version.... really it takes multiple angles of attack as people will find a way to be lazy or stupid.