VBA - How to auto update Microsoft Office Object Library

user_5860143 0
Viewed 10861

I writing some VBA code using Microsoft Office 16.0 Object Library. When I pass the file to another user who runs on Microsoft Office 14.0 Object Library. Once the function is being triggered, an error cannot find project and library will appear.

How can I auto update users using lower version of Microsoft Office Object Library to same version as mine?

My Reference

enter image description here

User 2 Reference

enter image description here

vba excel
1 Answers

Here's a good source of info:

Use Excel with earlier versions of Excel

Personally, I would check the users' version number in auto_open and then add/remove the reference as needed. More here and here.

Other options:

  • get a copy of the user's version of the Office Object Library and add it as a Reference on your machine, and uncheck 16.0 when it's time to save to distribute.
  • Install Excel 2010 as a 2nd version on your machine, and switch between as needed.
  • Upgrade all users to Office 2016

...or, is there I.T. department at this workplace?

  • Sounds like I.T.'s problem. Open a ticket. :-)
user_81127760
Related