Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workaround for com exe timer?? help
Hi fellow helpers,
I created this little ditty so that I wouldn't have to write the far more complex ActiveX exe (and because I have never written an ActiveX exe). The problem is I get an error with the following code on the starttime = now line. Dim c As Integer, starttimer As Integer c = 0 starttimer = Now() (I have also tried this: starttimer = Format(Now, "h:mm:ss")) Do While c = 0 If Range("A2") < "" Then c = 1 If c = 1 Then Exit Do If Now starttimer + TimeValue("0, 30, 0") Then GoTo KICKIT Loop I think what is happening is that starttimer may be continually updating to reflect "NOW", but I don't want it to do this. Is there a way to capture current time without it updating? Thanks, Nicole |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have a workaround | Excel Worksheet Functions | |||
Workaround no COUNTIFS in 2003 | Excel Worksheet Functions | |||
Help with circular reference. Need workaround | Excel Worksheet Functions | |||
Stopping a Timer / Running a timer simultaneously on Excel | Excel Discussion (Misc queries) | |||
csv load 64K workaround | Excel Worksheet Functions |