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
> >
>
>
>