Link to home
Start Free TrialLog in
Avatar of gdunn59
gdunn59

asked on

MS Access VBA Code to Include Library References

Can Library References be added via VBA Code?

Thanks,
gdunn59
Avatar of Norie
Norie

Which references do you want to add?
VBA provides two methods:

AddFromFile: https://msdn.microsoft.com/en-us/library/office/ff191786.aspx?f=255&MSPPError=-2147217396
AddFromGUID: https://msdn.microsoft.com/en-us/library/office/ff835634.aspx

That said, it is rare in the extreme to see these methods used in standard applications. What exactly are you trying to accomplish?
if you are having problems  regarding references in mix versions of office,
- develop/revised  your db app using the lowest version of office.
- use late binding (my preference) and worry no more about MISSING references.
ASKER CERTIFIED SOLUTION
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial