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.
1 件のコメント
Kaustubha Govind
2011 年 7 月 19 日
Try
MatLab.Execute("quit")
I don't know if this will fix the error though.
回答 (3 件)
Chirag Gupta
2011 年 7 月 19 日
Kaustubha's suggestion looks good to me. Is your routine f_ann finished when you try and exit?
0 件のコメント
参考
カテゴリ
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!