Why do I receive a "Compile error: Sub or Function not defined" error when calling Excel Link functions from an Excel VBA macro?

Question

MathWorks Support Team 2012-10-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/99133-why-do-i-receive-a-compile-error-sub-or-function-not-defined-error-when-calling-excel-link-functi

When calling any of the exported Excel Link functions (MLGetMatrix, MLPutVar, etc.) in an Excel VBA macro, I receive the following VBA error:

"Compile error: Sub or Function not defined"

请先登录，再回答此问题。

Answer 1

MathWorks Support Team 2012-10-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/99133-why-do-i-receive-a-compile-error-sub-or-function-not-defined-error-when-calling-excel-link-functi#answer_108480

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.