PDA

View Full Version : Solved: get server time



benong
09-23-2010, 10:43 PM
hi,
I want to put a excel workbook on LAN for all to use.
As each computer's time is not exactly the same, i wish to base on the server time as guide. Does anyone know the excel vba code to get the server time?

xld
09-24-2010, 02:36 AM
Why not get the time from an independent source, such as the US Navy.

Here is a post I answered somewhere else with a technique

http://www.excelforum.com/excel-programming/484627-vba-matching-values-and-time-synchronizing.html

benong
09-26-2010, 05:12 PM
dear xld,
many thanks for your guidance :)