MATLAB: Do I receive “Error in .Class1.1_0″ in Excel while using dll generated from MATLAB Builder EX in R2013b

MATLAB Builder EX

I am able to see the function in Excel but when I execute the function, I encounter the error "Error in <Component_name>.Class1.1_0" in Excel.

Best Answer

This is caused by "mwcomutil.dll" and "mwcommgr.dll" files not being registered. Please follow the steps below in order to register the dlls.

For 64 bit MATLAB

Development machine:

regsvr32 <matlabroot>bin\win64\mwcommgr.dll

regsvr32 <matlabroot>bin\win64\mwcomutil.dll

regsvr32 <project_dll_dir>\projectdll_1_0.dll

Deployment machine:

regsvr32 <mcrroot>\runtime\win64\mwcommgr.dll

regsvr32 <mcrroot>\win64\mwcomutil.dll

regsvr32 <project_dll_dir>\projectdll_1_0.dll

For 32 bit MATLAB

Development machine:

regsvr32 <matlabroot>\bin\win32\mwcommgr.dll

regsvr32 <matlabroot>\bin\win32\mwcomutil.dll

regsvr32 <project_dll_dir>\projectdll_1_0.dll

Deployment machine:

regsvr32 <mcrroot>\bin\win32\mwcommgr.dll

regsvr32 <mcrroot>\bin\runtime\win32\mwcomutil.dll

regsvr32 <project_dll_dir>\projectdll_1_0.dll

Please make sure to use 32 bit MATLAB with 32 bit Version of Microsoft Excel and 64 bit MATLAB with 64 bit version of Microsoft Excel.

Related Solutions

MATLAB: Do I receive a DLLRegisterServer error when using the MBUILD command from the MATLAB Compiler

This error generally indicates that the current user does not have sufficient permissions to modify the registry. The MBUILD command uses the MWREGSVR command to register two COM components with Windows.

To verify that the issue is permissions, open a DOS window and enter the following commands for releases prior to MATLAB R2009b:

 cd $MATLABROOT$\bin\$ARCH$
 regsvr32 mwcomutil.dll

For releases beginning with MATLAB R2009b:

 cd $MATLABROOT$\runtime\$ARCH$
 regsvr32 mwcomutil.dll

Where $MATLABROOT$ is the MATLAB root directory and can be found by typing MATLABROOT at the MATLAB command prompt. $ARCH$ is the computer's architecture, and is either WIN32 or WIN64.

If this command returns an error similar to the following: ERROR: DllRegisterServer in mwcomutil.dll failed. Return code was: 0x80070005

this will confirm that the cause of the MBUILD failure is insufficient permissions. For more information on regsvr32 permission requirements, refer to the following Microsoft reference URL:

http://support.microsoft.com/default.aspx?scid=kb;en-us;827659

NOTE: If you are encountering this issue on Microsoft Windows Vista, please ensure that you are running MATLAB as Administrator. To start MATLAB as Administrator, right-click on the MATLAB icon and select 'Administrator'.

MATLAB: Do I get an error message when I try to execute the deployed application created using MATLAB Builder EX on a 64-bit Windows machine

The reason that you are receiving this error could be due to the fact that the DLL needs to be registered manually on the deployment machine using the regsvr32 command from the system command prompt.

For example:

regsvr32 myExcelDLL.dll

You must also register mwcomutil.dll and mwcommgr.dll for each version of MATLAB or MATLAB Compiler Runtime (MCR) you are using.

After registering the components, restart the machine and retry running the batch file.

If you still receive the same error, the issue could be with vcredist(86) not being installed properly.

Run the dependency walker tool on the executable and check if it throws any warning related to ATL80.dll. If it does, then perform the following steps to rectify the issue:

1) Install vcredist from MATLAB Compiler Runtime (MCR) at:

$MCRROOT\$version\bin\win32\vcredist_x86.exe

where $MCRROOT is the installation folder of the MATLAB Compiler Runtime and $version is the MCR version (for example, v74 for MATLAB Compiler 4.4 (R2006a)).

2) Try running regsvr32r again. If it still fails, download the following update from Microsoft:

https://www.microsoft.com/en-us/download/details.aspx?id=14431

Best Answer

Related Solutions

MATLAB: Do I receive a DLLRegisterServer error when using the MBUILD command from the MATLAB Compiler

MATLAB: Do I get an error message when I try to execute the deployed application created using MATLAB Builder EX on a 64-bit Windows machine

Related Question