Posted to microsoft.public.excel.worksheet.functions

Posts: n/a

OnTime VB

I want to refresh my data every day at 12am. Does something like this
make sence?

Public RunWhen As Double

Sub StartTimer()

RunWhen = Time() = #12:00:00 AM# + TimeSerial(24, 0, 0)
Application.OnTime earliesttime:=RunWhen, procedu="The_Sub", _
schedule:=True
End Sub

Sub The_Sub()

ActiveWorkbook.RefreshAll
StartTimer

End Sub

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
OnTime VB	[email protected]	Excel Discussion (Misc queries)	5	May 17th 06 10:53 PM
Can someone explain OnTime?	hw	Excel Discussion (Misc queries)	1	May 4th 05 05:04 PM
Excel 2003 / Windows XP Pulsating Excel screen !!	monir	Excel Discussion (Misc queries)	9	February 7th 05 10:50 PM

All times are GMT +1. The time now is 12:47 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us