Declare References in Code

[Mmccl]

Help,

How do you declare references in VBA code? I have them checked in the references menu, but when I install my app on another pc some of the references are either not checked or are not in the same folder as the folder I reference to. Thus some of the commands in my app don't work.

ie. I copied msadox.dll to the same location as my app install folder and reffed it there, but when i install my app on a different pc it's referenced to a different location.

I want to make my app. so it is not dependent on the checked boxes.

How do you call or declare references in code?? I would like to do them all from my 1st start up form if possible

Thanks
Mike

 

[Mile-O]

I posted an example on this thread.