Code to install Word Object Libray

mikeymay

Well-known Member
Joined
Jan 17, 2006
Messages
1,416
I have a file that is used across machines that use Excel 2010 & 2013.

I need the relevant Word Object Library to be available to all users but user of 2010 run into an error as the 15.0 library is missing.

Therefore, I need to run some code in the Workbook_Open code to check which version and then install the relevant library. Ideally I want to future proof and check if Excel 2016 is being used.


Thanks
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,802
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
It will be much easier to late bind your code so that you don't need the reference at all.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,806
Messages
5,446,569
Members
405,408
Latest member
Bravomb96

This Week's Hot Topics

Top