Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
capturing a cell value at a specific time of day
Can i capture the value of a dynamically updating cell at
a specific time of day(from a linked realtime spreadsheet)? and if so how do i go about it? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
capturing a cell value at a specific time of day
Thomas,
Use OnTime that triggers a macro that captures the value. something like this which runs the macro after 2 mins (120 secs) Public dRun As Double Sub StartTimer() RunWhen = Now + TimeSerial(0, 0, 120) Application.OnTime earliesttime:=dRun, _ procedu="mySub", _ schedule:=True End Sub Sub mySub() Range("G3").Value = Range("C3").Value End Sub -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Thomas Donino" wrote in message ... Can i capture the value of a dynamically updating cell at a specific time of day(from a linked realtime spreadsheet)? and if so how do i go about it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Capturing Real Time Data | Excel Worksheet Functions | |||
Capturing Trend Data over time | Excel Discussion (Misc queries) | |||
VB Code Required for Capturing Time | Excel Discussion (Misc queries) | |||
Capturing average turn around time with constraints | Excel Worksheet Functions | |||
Date Capturing by Time | Excel Discussion (Misc queries) |