Include modules

[hals_left]

Is there any way to include a module at run time so that te latest
version is used.

I have several vba templates and want to share an alerts/messages
module, date handling module and database connection module rather than
having seperate copies of each modukle for each template.But all 3
modules are work in progress. How best to manage this so that when a
module is changed all templates use the latest version?

thanks
hals_left

 

[Jezebel]

Put the code into an add-in template. Then you need only one copy of the
code on each user's machine. To upgrade your code, replace the add-in.