Code to install Word Object Libray

[mikeymay]

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

 

[RoryA]

It will be much easier to late bind your code so that you don't need the reference at all.

 

[mikeymay]

Thanks RoryA but could you explain how to do this?

 

[RoryA]

See if this helps: VBA references and early binding vs late binding | Excel Matters

 

[mikeymay]

Thanks RoryA, I think that has done the job!