フィルターのクリア

Calling a GUI from excel and keeping it open

1 回表示 (過去 30 日間)
Johan
Johan 2011 年 6 月 6 日
Hi there, need a way to keep a GUI called from excel VBA code open, I am using matlab automation server as my code below shows:
Private Sub openmatlab()
Dim hMatlab As Object
Dim sDir As String, scdDir As String, s1 As String
Dim Result As String
Set hMatlab = CreateObject("matlab.application")
s1 = "'"
sDir = s1 & ActiveWorkbook.path & s1
scdDir = "cd(" & sDir & ")"
hMatlab.Execute (scdDir)
Result = hMatlab.Execute("starter")
MsgBox "Matlab er lukket", vbOK, "Matlab"
End Sub
As you might be able to see I am using a messagebox to stop the GUI from shutting down, but that makes excel "blink" all the time, and is annoying, any thoughts on how to do it better?

回答 (2 件)

Robert Cumming
Robert Cumming 2011 年 6 月 6 日
In your VBA code you could try the option
Application.ScreenUpdating = False
I have no experience of running matlab from Excel, but that used to stop the "blinking" back in the day when I ran macros.
  2 件のコメント
Johan
Johan 2011 年 6 月 6 日
yeah, already tried that, but it doesn't work, besides I would like a solution that doesn't involve using the msgbox, which is kinda 'cheating' in my opinion.
Johan
Johan 2011 年 6 月 6 日
But thanx anyways ;)

サインインしてコメントする。


Johan
Johan 2011 年 6 月 7 日
really no thoughts on this?
  2 件のコメント
Robert Cumming
Robert Cumming 2011 年 6 月 7 日
if you provide a bit more details?
What is your matlab function doing? Is it a GUI? and do you want to wait until the GUI closes before control returns to excel?
If so have you tried uiwait(yourGUIHandle). That should stop it.
Johan
Johan 2011 年 6 月 16 日
thanx a lot.

サインインしてコメントする。

カテゴリ

Help Center および File ExchangeData Import from MATLAB についてさらに検索

製品

Community Treasure Hunt

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

Start Hunting!

Translated by