Close Command after running MATLAB function in EXCEL VBA

4 次查看(过去 30 天)
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 CenterFile 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