Setting the system clock with excel

[ccdubs]

Hi,

I run a macro in an infinite loop for logging purposes. The problem is that
this seems to slow down the system clock.

One of the variables I am logging is a reference to time set on an external
device. Is it possible to use this to reset the system clock periodically?

Many thanks.

 

[Myrna Larson]

Check out the Date and Time *statements* in VBA Help.

 

[Guido]

what about using the OnTime event rather than an infinite loop?

Guido

HoloGuides
http://hologuides.com/programming/ExcelVBA

Hi,
Running a macro in an infinite loop will slow the system clock because
Windows isn't getting enough CPU cycles.
Do you use DoEvents in your loop?


--

John

johnf202 at hotmail dot com

Tom,

The system clock only slows down when the macro is running, otherwise it
remains fairly accurate.

I too was surprised at this and as yet I am unable to explain it.

All the macro does is write data to a text file and would be easy enough to
simulate if you are interested in trying it overnight on your own computer.

 

[ccdubs]

The "catch 22" is that I want as many cycles as possible and an accurate
time stamp.

I think I have resolved the issue (thanks to you all). The device that I am
reading data from has its own clock and I am using that clock as my time
stamp and I will also use it every hour or so to reset the system clock.
Just to keep things tidy.

Many thanks.

what about using the OnTime event rather than an infinite loop?

Guido

HoloGuides
http://hologuides.com/programming/ExcelVBA