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.

Learning even basic VBA scripting can completely change how you use Excel, turning it from a static tool into a personal automation powerhouse. By recording macros, tweaking simple code, and gradually ...