RE: [Talk] Code to know when Shell command is complete ...

[Corinna]

This is what I do   Sub Login() On error resume next  ' this allows the code to continue checking when an error is encountered Shell "to whatever your executable is" Do     err.clear  ' clear the error if previous attempt is unsuccessful     wait 1     activate "the title of the window you are going to connect to"  if it's not there yet it will throw an error and you keep looping until it is successful Loop Until Err = 0 Connect etc  'once you are able to activate window successfully it is available to connect to         Thanks, Corinna Robertson   Boston Software Systems [EMAIL PROTECTED] www.bostonworkstation.com The Essential Tool for Healthcare Integration 866-653-5105 ext. 5 508-653-5105   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mitchell Sherry - Mid West Div. Sent: Monday, May 02, 2005 4:29 PM To: '[EMAIL PROTECTED]' Subject: [Talk] Code to know when Shell command is complete ... We're seeing from previous emails - and our own code now - that the VB code continues on whether or not the Shell command code has completed --- so we're not sure what checking the return code from the Shell command is doing ...  We're looking for a way, or ways, to not go on to the next line of VB code until the Shell command code is done executing.     thanx, sherry HCA Midwest Division IT&S Applications Programmer/Analyst 816/823-0406