Automatically update VBA references using multiple versions of Excel (2013, 2016, 2019, and Microsoft Office 365)

[pingme89]

I have an excel file with VBA code. This file is saved on Dropbox.
I open this file from multiple locations with different versions of Excel installed.
I get Can't find Project error when running the code because the Excel Versions are different.

How can I automatically update the Reference to the proper Excel Version.

Missing: Microsoft Excel 15.0 Object Library

I need code to be able to detect all versions of Excel and Outlook and update the references accordingly.
Can someone point me in the right direction?

Thanks in advance.

 

[Zack Barresse]

Hello there,

The only way I know how to do this is via automation. The link below shows how to remove MISSING references and add them back. Should get you started. There's no real "good" solution for this IMO. Specifically for the Excel reference, your file should automatically update. The other way to reference objects is by using late binding, which will grab the systems current version if recognized. For example...

    Set OutlookApp = CreateObject("Outlook.Application")

https://support.microsoft.com/en-ca/help/308340/how-to-check-and-remove-incorrect-project-references-in-the-visual-bas