Pete Posted October 6, 2004 Report Share Posted October 6, 2004 I have an Excel application which spawns a msgbox when it is complete. My ME application has a "Wait For Window Title" command (waiting for the Excel Msgbox), it has a 15 sec timeout. Occasionally, it seems that the Excel app stops running UNTIL the wait for window command times out, and ME Macro is aborted - the Excel app then continues, and gives the msgbox. To me is seems that Macro Express is somehow stopping the Excel VBA from running - is this possible? I've tried using an "If window title is on top" command in a loop instead of the Wait for Window command, but the same thing happens. Quote Link to comment Share on other sites More sharing options...
floyd Posted October 6, 2004 Report Share Posted October 6, 2004 Is the title (if there is one) of the MsgBox dialog similar to the title of the current Excel window? Quote Link to comment Share on other sites More sharing options...
Pete Posted October 6, 2004 Author Report Share Posted October 6, 2004 Hi Floyd. No its not close. The strange thing is, it works fine 29 times out of 30. Quote Link to comment Share on other sites More sharing options...
floyd Posted October 15, 2004 Report Share Posted October 15, 2004 So for that one time, could it be that another window title from another application may be running somewhere with the same word(s) in it? This could also happen if you are running the macro from the editor and the macro name has the same word(s) in it. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.