I would like to know the suggested method(s) to load updates to a set of
macros contained in a .xls file. Using Excel 2000. Reason: Instead of
sending out the updated .xls files I would like the .xls files to look for,
check to see if there is a more recent update and then, if there is, load it
from a designated server. Maybe even change the server location where
updates are to come from next time.

I have seen .xls programs that have modules that check and load .xla files
with the updates. I have also seen code that will load individual modules.
Other methods? Recommended approach to follow?

Ken