A
Alon
Hello All,
How do I load in a library reference through VBA code (be it loading a
module or a reference to a another file containing the code needed).
When doing this, the code should also check if what I am loading has
already been loaded.
Similarly - unloading the reference via code.
The reason is that I have many functions which I use very often and
upon those I build other functions which I send off to other people in
my team to use. Rather then send them whole files though, I'd rather
send them a small piece of code that loads the required references,
calls the necessary funcitons/procs stored somewhere on a shared drive
and then unloads what has been loaded. This also allows me to make
changes to the original code w/out having to bug everyone with new
versions.
If my method is unpractical or unconventional for some reason and
someone has a better solution or approach I would really appreciate
your input on the matter.
Of course I would still like to know how to perform the above task.
Thanks,
Alon
How do I load in a library reference through VBA code (be it loading a
module or a reference to a another file containing the code needed).
When doing this, the code should also check if what I am loading has
already been loaded.
Similarly - unloading the reference via code.
The reason is that I have many functions which I use very often and
upon those I build other functions which I send off to other people in
my team to use. Rather then send them whole files though, I'd rather
send them a small piece of code that loads the required references,
calls the necessary funcitons/procs stored somewhere on a shared drive
and then unloads what has been loaded. This also allows me to make
changes to the original code w/out having to bug everyone with new
versions.
If my method is unpractical or unconventional for some reason and
someone has a better solution or approach I would really appreciate
your input on the matter.
Of course I would still like to know how to perform the above task.
Thanks,
Alon