I have many custom functions that I have written over the past year, and
many versions of the same functions distributed across various files
depending on when I wrote the file. This is bad. I would like to be
able to update all of those functions with the most current version.
However, doing that is very hard. And writing a program to go through
all the code of all the projects in a particular directory and prompting
to update with the new version is tedious.

I think a better approach is to have all the common functions that I
like to use in some central place. However, I do write code for Access
and Outlook, so I can't just store all of my code in an .xla file.
Perhaps a VB6 DLL or VB.NET addin. But other people in the office also
use these files, in which case they would need to install the DLL or
downloaded the .NET framework. I have experience writing in those
languages with the editors, so that would not be a problem should I
choose to do that. However, I have no experience distributing DLLs or
..NET compiled code, and I am afraid that pain might outweigh the costs.

Is there an option I am missing? If not, can someone with experience
with the above tell me just how difficult the distribution and dealing
with updates, etc, can be? Any help would be greatly appreciated.



Regards,
Robert Avery