ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Setting up Reference Library using VBA (https://www.excelbanter.com/excel-programming/281519-setting-up-reference-library-using-vba.html)

Alan

Setting up Reference Library using VBA
 

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.




Tom Ogilvy

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.







All times are GMT +1. The time now is 03:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com