Grab Server Time

[ianripping]

I have an excel worksheet with a clock that updates every 5 secs.

When the workbook is loaded iot grabs the system time. Could i
instead, grab the time of the server up which it sits on

 

[GJones]

Hi ianripping ;

If the workbook being opened is physically located on the
server, yes. If not you can make sure by including the
reserve word:

ThisWorkbook

in your call.

Thanks,

Greg