Inspired by the code in <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=vb&Number=100564&page=0 &view=expanded&sb=5&o=0&vc=1#Post100564>this post</A> by Andrew Cronnolly, here's (see attached Word doc) an implementation that provides a simplified interface for setting a reference to some common libraries (Access, Excel, PowerPoint, Word, VB Extensibility, and Scripting Runtime).
- not necessarily at the top of anyone's wish list; but Andrew's code just seems too cool to not use it for something.
This could be taken further: have the userform automatically display all currently set references, as well as a number of frequently-used ones. Via checkboxes you could permit the setting/unsetting of multiple references in one operation. (maybe to do some snowy weekend....)
Also, currently this has to be run from the application interface - it would be better if this could be run from the VBE instead - anyone know how?