ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Grab Server Time (https://www.excelbanter.com/excel-programming/310180-grab-server-time.html)

ianripping[_96_]

Grab Server Time
 
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

--
Message posted from http://www.ExcelForum.com


GJones

Grab Server Time
 
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

-----Original Message-----
I have an excel worksheet with a clock that updates every

5 secs.

When the workbook is loaded iot grabs the system time.

Could it
instead, grab the time of the server up which it sits on?


---
Message posted from http://www.ExcelForum.com/

.



All times are GMT +1. The time now is 11:13 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com