VBA Tools Reference-Check if enabled + enable if not?

Would it be possible to determine whether a specific VBA Tools Reference is enabled? (if possible without checking the registry)

If yes - would it be possible to enable that reference without user input required?

If no to the last question - would it be possible to prompt the user to enable the reference required?

Hi, mc84excel,

you´re not too specific about what you are asking...

Yes, can be (like said) but only of all references are working properly (no broken links). And the adding relates to which references you are looking for: a workbook distributed and fitted with the links should work correctly if the given or higher instance of reference is available.

Please Login or Register  to view this content.

Sample is for MS Visual Basic for Applications Extensiblity 5.3.

Ciao,
Holger

It also assumes your user has trusted access to the VBProject. It is almost always a simpler and better solution to late bind your code.

Originally Posted by HaHoBe

Sample is for MS Visual Basic for Applications Extensiblity 5.3.

Excellent. That happened to be the very library I wanted to enable programmatically.

Originally Posted by HaHoBe

you´re not too specific about what you are asking...

That was deliberate.

Originally Posted by romperstomper

It also assumes your user has trusted access to the VBProject.

True. Point taken.

I found this covered in detail on Chip Pearsons website: http://www.cpearson.com/excel/vbe.aspx (It had the enable Extensibility reference on there too. Oh well).

I have to say I can't see the need for this. I've never heard of the VBA Ext reference being broken or missing anyway, and late binding would be simpler.

Originally Posted by romperstomper

I have to say I can't see the need for this. I've never heard of the VBA Ext reference being broken or missing anyway

I work on one computer where it is impossible to access VBA Tools References (just gets this message 'Error accessing the system registry'). So I like the ability to enable a reference library programmatically.

Out of curiosity, does it work on that computer? I'd be more interested in fixing the issue but that's me (you still don't actually need the reference)

Originally Posted by romperstomper

Out of curiosity, does it work on that computer? I'd be more interested in fixing the issue but that's me (you still don't actually need the reference)

Yes the code worked fine. I find it handy to add a call to this sub at the start of code that requires use of that reference. (btw the computer has now been fixed )