Simple VBA question - equivalent of sleep

[MavrickStl]

Guys,

My excel macro runs a batch script using shell command and other VBA code. I would like to know what command in VB I can use to stop executing of VBA code until my batch script is finished.

VBA code lines1
somewhere in between I am calling shell to run a batch file
More VBA code lines2

What command I can use to stop execution of More VBA code lines2 until my batch operation is finished. In older days people used sleep to wait for a job to finished until the next one started

Thanks,

Amit

 

[mavest]

The secret is in using DoEvents this allows the system to pause and do other processing until a condition is met.

You could create a timer and wait a period of time as you loop through using DoEvents. When the time is up then the code will exit the loop.

I suggest searching this site for the keyword DoEvents and you are sure to find some good examples.