Is there a programatic way to set up references to needed type libraries in an Excel VBA macro?<P>Maybe I should explain why I want to do this. I'll be distributing the macro to a number of people.

A colleague of mine is doing some VBA coding, and finally getting into using classes to better structure the code. HOWEVER, he ran into a spot of bother with ...