get server time

[benong]

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?

[Bob Phillips]

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]

dear xld,
many thanks for your guidance :)