Posted to microsoft.public.excel.programming
|
|
Setting up Reference Library using VBA
http://support.microsoft.com/default...&Product=xlw97
XL97: How to Programmatically Create a Reference
--
Regards,
Tom Ogilvy
Alan wrote in message
...
Hi All,
I would like to be able to programmatically add a reference library
(for example, Word 9.0) as part of a sub.
At present, without the Word 9.0 reference library 'ticked', some code
runs very slowly.
I can add the library manually, but I would like to do it in the
Workbook_Open event code for all users so that I don't get complaints
or have to go around every machine.
Any suggestions?
Thanks,
Alan.
|