First login and Last logout times of windows system

[chinraj]

Hi,
I'm working on a vba project that needs to execute the windows system user's name, first login and last logout times of the day. The output should be updated(append on daily basis) in excel sheet colums A, B and C respectively

Any response/recommendations will be greatly appreciated

Thanks,
Chinraj

[swoop99]

How long have you been working on this VBA project and what have you got so far?

[chinraj]

Thank you for the reply.

I'm in beginning the of project(not expert with vba). Let me explain in detail, I want to measure the employee's in and out time on daily basis. I have two ideas to get this done.
1. Have a simple excel sheet with farmula(=now) in cell B2 and Environ("Username") in cell A2. the same sheet have been uploaded in Windows "Scheduled Tasks" to run at when user "Log on" the system.
Now I want to run the event macro when the users shutdown/logoff the computer and capture the details in cell C2 of the excel sheet.

2. There is a Event Log in the system(eventvwr.msc), we can export into csv too. From that we can get the source date, time, user, source, event id etc., i don't know the script that how to import the event log into local drive.

thank you again.

[swoop99]

I think you're barking up the wrong tree here completely.

Take user log on/off times direct from the server records. Trying to do this in Excel....well it could be done but why bother when windows server is already logging this data?