Hi Paul,
I had once seen a sheet, which used forms to take input from the user,
Plus: it also use to record the System lock time i.e. it would record
it as breaks automatically. I am not sure, what was the macro using to
feed itself with that data.
Shyam: The person who submited the query, wants
Dear All,
A clock indicating the current time is usually displayed in the task
bar of the PC.
One can hide the clock in the task bar if needed. However, hiding the clock does
not mean closing the clock itself. The clock actually runs in the background.
A computer has two clocks; a software clock
Would it be okay to have a .vbs script running under WSH capturing
that lock-down time and writing it in your spreadsheet? If yes, then
I'll look further into it... That's because a macro in Excel needs a
trigger to run, but a vbs-script can poll almost anything...
greetings
Paul Willekens
--
-
Paul,
I think SPS, wants to know, is there a way through which one can
capture system time, at the time when the user locks his/her system
i.e. in a networking environment, people usually press "Windows Key+L"
in order to lock there workstations, before they leave there seat. I
think SPS wants to
no need of VBA to see the system time in a spreadsheet... function
NOW() should do the job...
unless you would clarify what you mean with "at the time of locking
the system"... I hope you don't lock the system at all :)
cu
Paul Willekens
--
--
