Hi folks,

I have a little macros which at one point shells a .cmd file to run
minimised, almost
in the background as it were.

Shell "C:\Hotfixer\customscan.cmd", 2

The trouble is I don't want the user moving on into the next phase of
event handling until that
..cmd has completed what it needed to do. The user could end up querying
for data that the
..cmd hasn't yet returned.

What I want to do is have a "please wait" then a "OK Data retrieved"
kind of sequence
which starts when the shell spawns and the finishes when the .cmd
expires.

I'd be very grateful indeed for any advice or sample code.

I am very new to xlvba so the simpler it could be the better!!!

Many thanks,

========
Stuart