Why do I experience run-time errors when using Excel Link 2.2 (R14)?
9 次查看(过去 30 天)
显示 更早的评论
I have installed Excel Link for Microsoft Excel. However, when I invoke Excel, I experience the following Visual Basic popup error message:
Run-time error '-2147352567 (80020009)':
Array is not defined in the workspace
采纳的回答
MathWorks Support Team
2009-6-27
This bug has been fixed in Release 14 Service Pack 2 (R14SP2). For previous releases, please read below for any possible workarounds:
We have verified that there is a bug in Excel Link 2.2 (R14) in the way that it handles initialization. To work around this issue, try first invoking MATLAB as a COM automation server, and then invoking Excel. To invoke MATLAB as a COM automation server, open the Run dialog box by selecting Run from the Windows start menu. Then run the following command:
matlab /Automation
A minimized instance of MATLAB should appear. If you invoke Excel, it should now connect to this instance of MATLAB.
Another way of solving the problem is shown below:
1) Create a shortcut for MATLAB on the desktop.
2) Right click on the shortcut and select "Properties".
3) Type " /automation" after "...\bin\win32\MATLAB.exe" in the box next to Target.
In that case, you do not have to type " matlab /automation" from the Windows start menu. Instead you may start MATLAB in the automation mode using the new shortcut.
0 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!