How to capture the lock time and event of System by vba?

[Ratan Bhushan]

Hi Team

I have found code on few websites and trying to create the Macro in which I can capture the time and event of the lock and unlock of system.

I am attaching the file in which I am running macro for 60 seconds in which I locked and unlocked the system but the macro is only capturing "Unlocked" event.

Please help and check.

Thanks
RatanB

 

[Chihiro]

Why VBA? It's really not meant for this type of task and inefficient when compared to tools designed for this.

Run scheduled export of Event log on windows machine using task scheduler (as csv) and read the file.

Read link for details.
https://gallery.technet.microsoft.com/scriptcenter/Export-Windows-event-log-ecdfadfc

 

[Ratan Bhushan]

Why VBA? It's really not meant for this type of task and inefficient when compared to tools designed for this.

Run scheduled export of Event log on windows machine using task scheduler (as csv) and read the file.

Read link for details.
https://gallery.technet.microsoft.com/scriptcenter/Export-Windows-event-log-ecdfadfc

Chihiro - I want to use this in my time tracker program... which I am preparing in VBA.

This is where I have stucked..

Please suggest in VBA...

 

[vletm]

@Ratan Bhushan
Have You checked what values gives p_lngRtn in Check_If_Locked?
... I cannot test at all, but check this version...