Calling on a form upon the completion of a task.

how can i execute a shell command, then show a form based on the completion of the shell command? the form should not be displayed until the window state of the shell command window is closed.

i.e.:

shell("c:\windows\calc.exe"), vbNormalFocus
frmShow.Show <----- this form should not display until calc.exe is closed

Do a search in the help forum for 'ShellAndWait'

JDT

Thanks, JDT! I found one of your old posts and it worked perfectly.