waittime versus Sleep
 

What exactly is the difference between using the VBA
Application.Wait command and using Sleep() from the Windows API?

Thanks, Alan

waittime versus Sleep
 

The Wait method suspends all Microsoft Excel activity and may prevent you
from performing other operations on your computer while Wait is in effect.
However, background processes such as printing and recalculation continue
where as Windows Sleep API puts your macro gently to sleep and wakes it up
after a specified time. Your macro eats no processor cycles while it's
snoozing..

If this post helps click Yes
---------------
Jacob Skaria


"Alan" wrote:

What exactly is the difference between using the VBA
Application.Wait command and using Sleep() from the Windows API?

Thanks, Alan