View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Dana DeLouis[_3_] Dana DeLouis[_3_] is offline
external usenet poster
 
Posts: 690
Default Reset system clock?

I use to have a vba code that updated the time off the web when desired.
However, for the life of me, I can't seem to find it. It's better to use
one of the the downloadable program that can do this directly. However,
there is at least one program that I knew of that allowed it to be called
from a running program. I can't remember, but see if this is the program
from NIST.

http://www.boulder.nist.gov/timefreq/service/its.htm

Look for the Windows version in the upper right of the screen. Check out
help for "Command Line" calls.

Two other programs to check on the web are AtomTime, and Atomic Clock.

HTH.
Dana DeLouis


"Martin" wrote in message
...
I have a procedure that runs from 07:45 to 17:00. The procedure itself
appears to be slowing the system clock in that this computer now shows
system time as 14:39, whereas the computer next to it (and unconnected)
shows the correct time of 14:44.

I know I can reset the system clock by rebooting, is there any way that

VBA
can be used to reset the clock within another procedure? Or VB or Windows
API calls or anything??

Thank you
Martin