What you're trying to achieve by querying the time server every minute is a
very basic time synching system.

Note that your approach won't be all that accurate due to the overhead of
VBA, and pulling time via HTTP.

If you require that sort of time sensitive accuracy, you really should use
an NTP client.
Existing NTP clients will perform more accurate and more efficient time
synching than your approach will.

Additionally, think that you will have to keep maintaining your product with
bug fixes, support, etc...
Why bother with that hassle when NTP clients are already well supported, bug
fixed, and some good ones are FREE.

Check out http://www.ntp.org and
http://www.boulder.nist.gov/timefreq...ftwarelist.htm


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"MB" wrote in message
...
The procedure runs all day, once a minute and is not only to be used on
one
machine. It's not practical to specify that any other machine should have
an
NTP client to run it.

Martin

Rob van Gelder wrote in message ...
I'm confused as to why you even need to query the master clock. That's
what
NTP clients do.

If you install an NTP client (I believe Windows XP comes with one as
standard), then you can use the system clock.


--
Rob van Gelder - http://www.vangelder.co.nz/excel