add a reference to Microsoft Visual Basic for Applications Extensibility" at run time

Hi
I've been on the WEB most of the day trying to figure this out. Is there code to "add a reference to Microsoft Visual Basic for Applications Extensibility" at run time.
I have this code that seems to require such a reference

Please Login or Register  to view this content.

And it results in this (after I set the reference manually)

Please Login or Register  to view this content.

Can I set the Reference pragmatically?
As always, your help is deeply appreciated.
John

If you add the reference manually (Tools -> References) when the file is distributed then assuming the same library is available on the other clients the library will be available.

You can add references via the Workbook Open event but unless there are version specific issues with the library itself it's often not necessary.

You could also just late bind and not worry about the reference.

Hi DonkeyOte

This is REALLY what I am asking

You can add references via the Workbook Open event

I was all over the Internet for hours looking for code to do just that. Alas, to know avail. Any idea what the code is to do that?

Hi romperstomper

I solved the issue by

just late bind and not worry about the reference

Thanks to both of you. I'll leave this as unsolved for a few days to see if I get feedback on the code question.

John

You can develop early-bound, test both early- and late-bound, and then leave it whichever way you like. For example,

Please Login or Register  to view this content.

That way you get IntelliSense during development.

Programmatically it would be:

Please Login or Register  to view this content.

for example.

Hi romperstomper

After your last post, I searched on

VBProject.References.AddFromGuid

and found a wealth of information. Just didn't know what to search for. Thanks for that!

John