View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default Reset system clock?

I keep a shortcut to a .vbs file on my desktop. I stole it from Bill James &
Michael Harris:

http://groups.google.com/groups?thre...%40tkmsftngp04

I can just double click on it whenever I'm connected to the internet. And I
don't have to load a special workbook in xl to adjust the time.



Martin wrote:

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


--

Dave Peterson