How to register library/reference from vba code? (3 Viewers)

amorosik

Active member
Local time
Today, 23:58
Joined
Apr 18, 2020
Messages
697
I have an Access procedure that searches for newer versions upon startup
If available, downloads them to the root program directory and creates a new icon on the desktop to launch them
Sometimes, newer versions require an additional library in the references; otherwise, the code won't work correctly
The question is: how can I verify that all the required libraries are loaded, and if not, how can I start the library registration process (using VBA code, I mean)?
 
Last edited:
OK, first... references are found via Application.References, which you can look up with a browser. If you have Google with Gemini, you can ask for it to tell you "vba to manipulate ms access references" and you'll get a list. You can do AddFromFile or AddFromGUID to add a reference, and Remove to remove a reference. Look up those items to get some example code.

Another good search string is "Add references programatically with VBA"
 

Users who are viewing this thread

  • Back
    Top Bottom