Auto Load Reference Library

[jdlc]

Hi,

I write VBA code that sometimes ends up on other's computers. When they run the code they sometimes get errors since they do not have the needed library references included (.eg. VBE..Tool Bar...Tools..references... Calendar, ADO library , etc)

Does anyone know how to have the VBA code check to see if all required references have been included and if not ... then include them ?

And if you do, then a little VBA code demo would be appreciatted.

Thanks.

[jaslake]

Hi jdlc

See these two links...
http://xlvba.fr.yuku.com/topic/131#.U49pokrD_s0
http://xlvba.fr.yuku.com/topic/200#.U49qM0rD_s0

[jdlc]

woooah! this great! thanks john.

[jaslake]

Hi jdlc

You're welcome...glad I could help. Thanks for the Rep.

You mention Calendar as one of a possible Reference Requirement. Perhaps not all of your Users will have Calendar Control loaded on their machine and this will not resolve the issue for them.

I suggest you Google on Non ActiveX Calendar Control...think about using that...such will avoid the issue of a required Reference for Calendar Control.

[jdlc]

Thanks John for the input.