Close Command after running MATLAB function in EXCEL VBA

4 次查看（过去 30 天）
Surae
Surae 2011-7-19
Hi,
I'm finding a close command after running a M file in EXCEL VBA.
Because I got a alert message like "Microsoft Office Excel is waiting for another application to complete on OLE action" after running a M file in Excel VBA.
Do you have any idea about the close MATLAB application command in VBA?
Dim MatLab As Object
Dim Result As String
Set MatLab = CreateObject("MatLab.desktop.Application")
Result = MatLab.Execute("cd('C:\Documents and Settings\M02043\Desktop\MATLAB Interface Test')")
Result = MatLab.Execute("f_ann")
End Sub
Thanks a lot in advance.

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

回答（3 个）

Surae
Surae 2011-7-20
Hi,
I got an solution for this issue. Please have a look at following if anyone have a similar problem like me.
This alert message seems to occur from MS office itself due to using an external application and I could disregard the message as below.
Good luck.
Dim lDisplayAlerts as Boolean
lDisplayAlerts = Application.DisplayAlerts
Application.DisplayAlerts = False
.
.
.
.
Application.DisplayAlerts = lDisplayAlerts
Chirag Gupta
Chirag Gupta 2011-7-19
Kaustubha's suggestion looks good to me. Is your routine f_ann finished when you try and exit?
Surae
Surae 2011-7-19
Hi,
I tried it with below Macro already but I still couldn't exit Matlab application without closing "Microsoft Excel Office Excel is waiting ... OLE action" message.
Result = MatLab.Execute("quit")
'exit' also doesn't work.
Is there anybody having a similar problem like me? Thanks,

类别

在 Help Center 和 File Exchange 中查找有关 Data Export to MATLAB 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by