net time

[ETID]

Any body know how to pass the net time (network date and time info) to a string variable in vba?

 

[xlbo]

erm.....
myNetworkDateAndTime = Now()

should do it shouldn't it......
Computer clock set from network clock
Now() = computer clock time
HTH
Geoff

 

[ETID]

Thanks for your reply...

The trouble is,... the local machines are not turned off on a scheduled interval, so the clocks are not syncronized to the network every day, but I have a process that is run locally every day that is dependent on having the exact or net time, So I need to capture the exact time according to the net server.

I.E. "net time" from command prompt.