Shell Synchornous?

[Rwostbrock]

"....By default, the Shell function runs other programs asynchronously. This
means that a program started with Shell might not finish executing before the
statements following the Shell function are executed...."

Is there a way to force the shell function to run in a synchronous manner?
I want to use the shell function to execute the dos command xcacls. The time
for the command to complete varies with every run and needs to be finished
before the next vba line executes. Therefore, a simple wait XXX seconds
routine will not work for me.

Rich

[Ron de Bruin]

Hi Rich

You can use ShellAndWait
See the vba example on this page
http://www.rondebruin.nl/csv.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Rwostbrock" <[email protected]> wrote in message news:[email protected]...
> "....By default, the Shell function runs other programs asynchronously. This
> means that a program started with Shell might not finish executing before the
> statements following the Shell function are executed...."
>
> Is there a way to force the shell function to run in a synchronous manner?
> I want to use the shell function to execute the dos command xcacls. The time
> for the command to complete varies with every run and needs to be finished
> before the next vba line executes. Therefore, a simple wait XXX seconds
> routine will not work for me.
>
> Rich
>

[Rwostbrock]

PERFECT!

Thanks

"Ron de Bruin" wrote:

> Hi Rich
>
> You can use ShellAndWait
> See the vba example on this page
> http://www.rondebruin.nl/csv.htm
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "Rwostbrock" <[email protected]> wrote in message news:[email protected]...
> > "....By default, the Shell function runs other programs asynchronously. This
> > means that a program started with Shell might not finish executing before the
> > statements following the Shell function are executed...."
> >
> > Is there a way to force the shell function to run in a synchronous manner?
> > I want to use the shell function to execute the dos command xcacls. The time
> > for the command to complete varies with every run and needs to be finished
> > before the next vba line executes. Therefore, a simple wait XXX seconds
> > routine will not work for me.
> >
> > Rich
> >
>
>
>