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

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" wrote in message ...
"....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

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" wrote in message ...
"....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