Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
waittime versus Sleep
What exactly is the difference between using the VBA
Application.Wait command and using Sleep() from the Windows API? Thanks, Alan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Earn when you sleep | New Users to Excel | |||
Sleep Mode | Excel Programming | |||
Calculating Sleep | New Users to Excel | |||
Baby Sleep log | Charts and Charting in Excel | |||
Web Query Sleep for until results come | Excel Worksheet Functions |