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.

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.