Why do I receive a "module could not be found" error when I try to run an application that uses a MATLAB Builder for Excel COM object?

I have called a MATLAB Builder for Excel COM object from my Excel application. However, when I try to run the application, I receive the following error in a popup box:

 LoadLibrary("mgr.dll") failed

 The specified module could not be found.

Answer 1

[MathWorks Support Team]

This bug has been fixed in Release 14 Service Pack 3 (R14SP3). For previous product releases, read below for any possible workarounds:

This error message is usually generated when the system cannot find a required DLL on your system path.

If the error occurs on your development machine, make sure that the following directory is on your system path:

$MATLAB\bin\win32

where $MATLAB is your MATLAB root directory, resides .

If the error occurs on your target machine, check the following:

*The MATLAB Component Runtime (MCR) must be installed on the target machine.

*The MCR must be on the system path for the target machine.

*The version of MCR that is installed on the target must match the version of MATLAB that you used to compile the COM object on your development machine.

If you still receive the "module not found" error, try using Dependency Walker to debug the problem.

Dependency Walker is a free utility for troubleshooting system errors related to loading and executing modules.You can find this software at the following website:

http://www.dependencywalker.com/