12-03-2010, 05:05 AM
I'm runing a simple QM generated exe macro from an Excel macro as follows:
Dim RetVal
RetVal = Shell("E:\RUN\QMMACRO.EXE", 1)
My question is how do I detect when a QM macro RT error occurs - specifically the QM macro enters a number in a window and clicks on a submit button, but when that window is not there, QM logs the error OK in its debug window. But I want to be able to detect this in my Excel macro also by some return value.
When I check the value of "RetVal" above in my Excel macro, even when a window not found error happens, it is always a positive value such as 2238 4468 etc....
Thanks for any help.
Dim RetVal
RetVal = Shell("E:\RUN\QMMACRO.EXE", 1)
My question is how do I detect when a QM macro RT error occurs - specifically the QM macro enters a number in a window and clicks on a submit button, but when that window is not there, QM logs the error OK in its debug window. But I want to be able to detect this in my Excel macro also by some return value.
When I check the value of "RetVal" above in my Excel macro, even when a window not found error happens, it is always a positive value such as 2238 4468 etc....
Thanks for any help.