Checking references automatically through code?

I have an excel add-in that has got few macros which require two references,

1) Microsoft Word 12.0 object library
2) Microsoft Internet Controls

I have checked both these references and the macros are running perfectly on my PC. but when I distribute this add-in, sometimes the references are checked but sometimes it gives an error and the user is required to check the reference again.

Can i use some code to automatically check these two references. or is there some other easier way to get rid of this error.

Regards,
Vaibhav

Do all users run the same version of Office and do people run a complete suite of Office in one version or have a mix - ie Excel 2007 but Word 2003 etc...
If you run different versions you will find trying to register 12.0 on an 11.0 machine will generate an error given the library doesn't exist... if everyone's XL version = Word version you can use

Please Login or Register  to view this content.

as basis to determine which library to install... alternatively

Please Login or Register  to view this content.

Something like the above would give you the version but you can see also the above utilising late-binding does not require the object library at all.

overview of late vs early: http://www.*****-clicks.com/excel/olBinding.htm

If everyone runs consistent suite of apps then things are relatively straightforward for early binding, eg:

Please Login or Register  to view this content.

and if desired run a remove before closing the file (could cause issues if library being used in other files in same application instance)

Please Login or Register  to view this content.

Both of the above residing in ThisWorkbook object.

In a separate module, the below code:

Please Login or Register  to view this content.

(In 2007 MS Internet Controls is seemingly not listed by default in References)

You didn't specify what errors you were getting previously... if you try and add the library and it's referenced already you would generate an error, the above has a handler in place... obviously the handler means that if it's not added because it's not available then your other code will still a generate an error given the objects used can't be found (as library not referenced)

re: the other library-less approach ... this is late binding... you will find lots of articles on line about the method, far superior to anything I could put together... in short late binding can be a little slower but more importantly harder to code as you don't have intellisense when you put it together, the advantage is of course you don't need to reference the library... early binding with libraries gets more complex if you run multiple versions as libraries are not backwards compatible... ie someone using say Word 12.0 library who forwards the file to someone on 2003 (11.0) will generate an error.

I should add that elements of the above code are based off code posted by Leith Ross here previously...

http://support.microsoft.com/kb/282830

Hey DonkeyOTE,

That worked perfectly!!!!

Thanks a lot.........

one more small question..

by following your procedure, can I by any chance encounter any kind of error related to the reference part.. though you have written "On Error Resume Next"

I cannot see any error in the code that you have written.. but still I just want to be sure.. as you are the expert

Thanks again..