How do I add a reference at run-time?

[yonglove]

Our shop has VBA code that is in need of an upgrade. I have done the upgrade using the reference MSADO15.DLL

Our LAN auto-run programs have copied the DLL from the network to the local drives upon login and registered the DLL using REGSVR32.

Can someone please tell me how can I add the reference programmatically using VB (instead of going to each PC and clicking on TOOLS, ADD REFERENCE, etc...) ?

Thank you so much!

------------------
Eben Yong
[email protected]

[Clunietp]

All you have to do is compile your app with the same version of the DLL file and distribute the EXE as normal. The clients will be able to find the new DLL based on the Class ID, which will be the same on every computer if the same file was registered on each computer.