waittime versus Sleep

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

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

Thanks, Alan
 
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
 
Back
Top