Determine if there is a library referenced in VBA code

[joe31623]

I would like to use early binding for dictionary objects if the Microsoft Scripting Runtime library is referenced; however, if my macro runs on a machine that did not reference the library, I would like to use late-binding.

For example, I would like to do something like this:

Please Login or Register  to view this content.

I know that will not work because the declarations are made before the If-Else statement runs, but is there any way to accomplish what I want to do (conceptually) above?

I think it would make solving Forum member's solutions easier because it would allow me to take advantage of the intellesense list of a dictionary object without changing the code for solutions I post in the forum. And I'd learn more about VBA if I could determine which libraries are referenced in VBA.

[LJMetzger]

Hi,

Great Idea. I don't think you will be able to find an acceptable solution.

I offer the following poor man's alternative using CONDITIONAL COMPILATION:

Please Login or Register  to view this content.

Lewis

[joe31623]

INTERESTING!!!

I had no idea what a preprocessor command was before I delved into your solution. That is exactly what I was looking for, Lewis! That allows me to use the intellesense list, which makes me feel all warm and fuzzy as I code since I'm still developing my object-orientated skills. I don't want to have to keep giving novice forum users instructions on how to reference a library because it will confuse many people.

Once again, thank you very much!!!