So, I have a slightly weird one I hope You can help me with since Googling didn't help.

I have a software that has an API integration to Excel through the VBA Project Reference library. I often calculate in this software and use VBA to import results to Excel for further sharing and analysis.

Now, I have colleagues who doesne't have this software installed, but for whom I need to give the results in a manner so they can choose between settings and outputs, also using VBA.

Is there a way I can disable some of my Workbook's functionality if the reference is broken?

From this Microsoft Support link I can see a method to check the if the reference works, but not to check if it is available or not.

What I want the Sub to do:
On Open -> Check if the specific reference is available in the library
  • If TRUE, enable it and carry on
  • If FALSE, disable the broken reference, and run some other code (to hide missing functionality)

Code from link that seems to be close:
Please Login or Register  to view this content.
I hope You can help,


GregersDK