Hey all,

I am building a workbook that is used to keep track of equipment and labor, per project, for my company. As has been the case in the past, sometimes a new feature is desired, or a formula has a typo or something. Rather than go through and update all the previous versions, I would like to write the update once and have them update themselves.

What I would like to do is have a button that the user can click that checks for updates. Then whenever I do have to make a change, I make the changes with macros and save them into another workbook.

Basically the way I figure this thing would work is that it would open the other workbook, compare the version number, and if a greater version number exists, run a set of macros to perform all the updates. If the version number is the same, it displays a message "No updates availible" and closes the workbook.

So basically I need to know a few things:
1) Is the way I outlined the best way of doing it, or is there a better way?
a) Is it better to call a subroutine from from the book to be updated or use a workbook_open() function on the updating sheet?

2) Can someone give me an example of a code that replaces a userform/module?

Thanks guys,
Wilro85