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 & ")"
Result = hMatlab.Execute("starter")
MsgBox "Matlab er lukket", vbOK, "Matlab"
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?