It is quite possible, if you know the name of the library reference.
You can try adding it like

Thisworkbook.VBProject.References.AddFromFile FileName:="C:\Program
files\Common Files\(name of your reference)"

Just substitue this with your directory and reference name



"Ayo" wrote:

I developed an Excel macro but some people can't use it because they don't
have the object libraries needed in their Excel application. How do you add
object libraries to your VBA that are missing?