Programatic Reference to Libraries

[Wayne S.]

Is it possible to set a reference to a library programmatically like I
can do for an add-in?

Thanks in advance for any help.

[Chip Pearson]

Yes. If you know the name of the library file, you can use code
like the following:

ThisWorkbook.VBProject.References.AddFromFile _
Filename:="H:\whatever\typelib.olb"

If the typelib has been registered, and you know the GUID and
version numbers, you can use code like

ThisWorkbook.VBProject.References.AddFromGuid _
GUID:="{ whatever }", Major:=x, Minor:=y


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Wayne S." <Wayne [email protected]> wrote in message
news:[email protected]...
> Is it possible to set a reference to a library programmatically
> like I
> can do for an add-in?
>
> Thanks in advance for any help.
>
>
>