MATLAB: In Excel Link, why do I receive the error: Sub or Function Not Defined

definederrorexcelfunctionlinknameSpreadsheet Linksub

In Excel Link, I receive the following error:

Sub or Function Not Defined

Excel Link does not recognize the MLPutMatrix command inside the macro. The same command works fine if I enter it inside the Worksheet.

Best Answer

The reason that you are receiving this error is that you must configure Excel to reference these functions within a macro. Follow these instructions to configure Excel properly:

1. If it is not already opened, open the Visual Basic Editor in Microsoft Excel (Alt+F11).

2. Pull down the Insert menu, select Macro and select Module.

3. When the Module page opens, pull down the Tools menu and select References...

4. In the References window, check the box for EXCLLINK.XLA and click OK. You may have to use "Browse..." to find the EXCLLINK.XLA file.

See the documentation for more information:

http://www.mathworks.com/help/exlink/matlab-commands-in-microsoft-excel.html

Related Solutions

MATLAB: Do I receive a “Compile error: Sub or Function not defined” error when calling Excel Link functions from an Excel VBA macro

This error occurs because in Excel VBA, a reference must be set to another application in order to use that application's objects. To set a reference in your VBA project to Excel Link, perform the following steps:

1. Open the Microsoft Visual Basic development environment associated with the version of Excel you are using. Typically, you can browse in Excel by going to the 'Developer' Tab and click on the 'Visual Basic' icon (possibly the first icon on the left). Otherwise, Alt + F11 is another shortcut to open this utility.

2. In the Microsoft Visual Basic development window's project browser, click on your project.

3. From the "Tools" menu, select "References"

4. Check the "Excllink" box and click "OK"

Note: If the "Excllink" box does not appear in the references, make sure that Excel Link is selected as an add-in to Excel.

MATLAB: Do I get excllink.xla error when I try to load the MS Excel data into Spreadsheet Link EX 3.0.2 (R2008b)

The missing excllink.xla error message normally occurs when the SpreadSheet Link Ex is not available in the installation directory.

To work around the issue, install Spreadsheet Link EX and then, follow the instructions in the link below to configure Spreadsheet Link EX add-in with MS Excel 2003:

 <http://www.mathworks.com/access/helpdesk/help/toolbox/exlink/bq8lkuy.html>

Best Answer

Related Solutions

MATLAB: Do I receive a “Compile error: Sub or Function not defined” error when calling Excel Link functions from an Excel VBA macro

MATLAB: Do I get excllink.xla error when I try to load the MS Excel data into Spreadsheet Link EX 3.0.2 (R2008b)

Related Question