How do I use two different versions of MATLAB Compiler Runtime with VBA code for MATLAB Builder for Excel?

I want to use two different versions of the MATLAB Compiler Runtime (MCR) in my application that uses a component or add-in built with MATLAB Builder for Excel.

When I try to do so, I get the following error message:

Error: -2147023782 (8007045a)

Source: VBAProject

Message: Automation error A dynamic link library (DLL) initialization routine failed.

Answer 1

[MathWorks Support Team]

It is not possible to use add-ins that were compiled with different versions of MATLAB Builder for Excel from within the same application; however they can be accessed from separate applications.

In order for your add-ins to be accessed from separate applications, you will need to make sure that both versions of MATLAB or MATLAB Compiler Runtime (MCR) are on the path, and that both the components have been registered on the machine (via regsvr32/mwregsvr).

You must also register mwcomutil.dll and mwcommgr.dll for each version of MATLAB or MCR you are using. To learn more about registering components, refer to the following documentation:

https://www.mathworks.com/help/compiler_sdk/com/registering-and-referencing-the-utility-library.html

In the VBA code, you can invoke the version-specific mwcomutil.dll by using the syntax

             Set MCLUtil = CreateObject("MWComUtil.MWUtil7.4") ' To use version 7.4

or the version-independent DLL using

             Set MCLUtil = CreateObject("MWComUtil.MWUtil") '<---can end MWUtil with 7.4 or 7.2 or appropriate version