Keep Awake Nudge
On Sun, 2 Mar 2008 12:24:01 -0800, JLGWhiz
wrote:
You could use two OnTime macros that call each other every 15 minutes.
Sub WakeUp()
Application.OnTime Now + TimeValue("00:15:00"), "Nudge"
End Sub
Sub Nudge()
Application.OnTime Now + TiveValue("00:15:00"), "WakeUp"
End Sub
-----------------------------------
That's a very tidy, neat solution, but... Can you explain how this
keeps the OS from entering sleep mode? I'm already madly calling a
bunch of interrelated subroutines.
Is the "Application.OnTime" statement itself going to somehow keep the
OS from sleeping?
Thanks.
Bill
|