Is there a way to add a reference?

[Kenji]

Is there a way to add a "reference" or "library" through VBA? I want my
excel sheet to add the "MSXML" library.. only if the person's running
Windows. Thanks!

Kenji

 

[Tom Ogilvy]

Yes, use the references collection (AddFromfile or AddFromGuid) in the MS
Visual Basic Extensibility Library. Create a reference to it an see help
for details.

 

[Kenji]

Tom,
I want to add it through code. I want to put a check on a library in my
reference through VBA code.

Kenji

 

[Tom Ogilvy]

That is what I told you how to do.

http://support.microsoft.com/default.aspx?scid=kb;en-us;213529&Product=xlw
XL2000: How to Programmatically Create a Reference

http://support.microsoft.com/default.aspx?scid=kb;en-us;160647&Product=xlw
XL97: How to Programmatically Create a Reference

You only need to create a reference to the extensibility library so you can
see it in the object browser - helpful in learning how to use it.