Why do I receive a "Compile error: Sub or Function not defined" error when calling Excel Link functions from an Excel VBA macro?
显示 更早的评论
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"
采纳的回答
MathWorks Support Team
2012-10-22
0 个投票
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.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Data Export to MATLAB 的更多信息
2012-10-22
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
