I have a workbook which automates some testing (loading results etc) and is used by a number of users.
My copy is the "master" and is not available to them other than as a read-only version from which they "save as" their own versions (they each have several copies of it - one per test case they are building)
When I first created this "tool" I thought about releasing new versions of the main macros that sit inside it. The approach I took was to have a workbook_open macro that loaded the latest version of the main macros from a .bas file on the LAN. This has worked a treat but I've now hit a slight snag.
I want to make the workbook_open macro do some extra bits as well. Obviously that's easy for me to do in MY copy but I want to distribute the latest workbook_open to all users.
I'm about to set off opening loads of their workbooks and copy/pasting my new version in but I feel sure this will need to be done again at some point so would like to take the opportunity to make it future-proof.
Is there any way I can set the workbook_open macro to check for new versions of ITSELF in a given location? Probably not but if anyone has any brilliant ideas how to achieve the same result I would be grateful.
Bookmarks