MATLAB Excel Builder

Troubleshooting

This section provides a table showing errors you may encounter using MATLAB Excel Builder, probable causes for these errors, and suggested solutions.

Table E-1: MATLAB Excel Builder Errors and Suggested Solutions
Message
Probable Cause
Suggested Solution

MBUILD.BAT: Error: The chosen compiler does not support building COM objects.
The chosen compiler does not support building COM objects.

Rerun mbuild -setup and choose a supported compiler.

Error in component_name.class_name.1_0: Error getting data conversion flags.
Usually caused by mwcomutil.dll not being registered.

Open a DOS window, change directories to <matlab>\bin\win32 (<matlab> represents the location of MATLAB on your system), and run the command
mwregsvr mwcomutil.dll.

Error in VBAProject: ActiveX component can't create object.
1. Project DLL is not registered.
2. An incompatible MATLAB DLL exists somewhere on the system path.

If the DLL is not registered, open a DOS window, change directories to <projectdir>\distrib (<projectdir> represents the location of your project files), and run the command:
mwregsvr <projectdll>.dll.

Error in VBAProject: Automation error The specified module could not be found.

This usually occurs if MATLAB is not on the system path.

Place <matlab>\bin\win32 on your path.

LoadLibrary("component_name_1_0.dll") failed - The specified module could not be found.

You may get this error message while registering the project DLL from the DOS prompt. This usually occurs if MATLAB is not on the system path.
Place <matlab>\bin\win32 on your path.

Cannot recompile the M file xxxx because it is already in the library libmmfile.mlib.

The name you have chosen for your M-file duplicates the name of an M-file already in the library of precompiled M-files.
Rename the M-file, choosing a name that does not duplicate the name of an M-file already in the library of precompiled M-files.

Table E-1: **MATLAB Excel Builder Errors and Suggested Solutions**
Message	Probable Cause	Suggested Solution
`MBUILD.BAT: Error: The chosen compiler does not support building COM objects.`	The chosen compiler does not support building COM objects.	Rerun `mbuild -setup` and choose a supported compiler.
`Error in component_name.class_name.1_0: Error getting data conversion flags.`	Usually caused by `mwcomutil.dll` not being registered.	Open a DOS window, change directories to `<matlab>\bin\win32` (`<matlab>` represents the location of MATLAB on your system), and run the command `mwregsvr mwcomutil.dll`.
`Error in VBAProject: ActiveX component can't create object.`	1. Project DLL is not registered. 2. An incompatible MATLAB DLL exists somewhere on the system path.	If the DLL is not registered, open a DOS window, change directories to `<projectdir>\distrib` (`<projectdir>` represents the location of your project files), and run the command: `mwregsvr <projectdll>.dll`.
`Error in VBAProject: Automation error The specified module could not be found.`	This usually occurs if MATLAB is not on the system path.	Place `<matlab>\bin\win32` on your path.

`LoadLibrary("component_name_1_0.dll") failed - The specified module could not be found.`	You may get this error message while registering the project DLL from the DOS prompt. This usually occurs if MATLAB is not on the system path.	Place `<matlab>\bin\win32` on your path.
`Cannot recompile the M file xxxx because it is already in the library libmmfile.mlib.`	The name you have chosen for your M-file duplicates the name of an M-file already in the library of precompiled M-files.	Rename the M-file, choosing a name that does not duplicate the name of an M-file already in the library of precompiled M-files.

Table E-2: Excel Errors and Suggested Solutions
Message
Probable Cause
Suggested Solution

The Macros in this project are disabled. Please refer to the online help or documentation of the host application to determine how to enable macros.
Note: Wording may vary depending upon the version of Excel you are running.

The macro security for Excel is set to High.
Set Excel macro security to Medium on the Security Level tab (Tools > Macro > Security).

**Table E-2: Excel Errors and Suggested Solutions**
Message	Probable Cause	Suggested Solution
`The Macros in this project are disabled. Please refer to the online help or documentation of the host application to determine how to enable macros.` `Note: Wording may vary depending upon the version of Excel you are running.`	The macro security for Excel is set to High.	Set Excel macro security to Medium on the Security Level tab (Tools > Macro > Security).

Table E-3: Function Wizard Problems
Problem
Probable Cause
Suggested Solution

The Function Wizard Help does not display.
The Function Wizard Help file (mlfunction.chm) is not in the same directory as the Function Wizard add-in (mlfunction.xla).
Copy the Help file (mlfunction.chm) into the same directory as the add-in.

**Table E-3: Function Wizard Problems**
Problem	Probable Cause	Suggested Solution
The Function Wizard Help does not display.	The Function Wizard Help file (`mlfunction.chm`) is not in the same directory as the Function Wizard add-in (`mlfunction.xla`).	Copy the Help file (`mlfunction.chm`) into the same directory as the add-in.

Enum mwDateFormat