PDA

View Full Version : capture Windows user name and login/logoff date time



jigar1276
12-20-2012, 01:45 PM
Hi,

I am looking for the macro which should get me the windows xp user id, loggin and log off date and time in excel sheet.

I tried but getting only user name but unable to get the windows xp login and log off date and time.

Thanks in advance,
Jigar

Kenneth Hobs
12-20-2012, 02:16 PM
www.logparser.com

jigar1276
12-25-2012, 10:13 AM
www.logparser.com (http://www.logparser.com)

Unable to open this website...

Kenneth Hobs
12-25-2012, 01:03 PM
Search for logparser for other links.

http://www.vbaexpress.com/forum/showthread.php?t=27662
http://www.vbaexpress.com/forum/showthread.php?t=29956
http://support.microsoft.com/kb/910447
http://www.microsoft.com/en-us/download/details.aspx?id=24659
etc.

Paul_Hossler
12-26-2012, 10:49 AM
'http://vb.mvps.org/samples/TimeZone/
'http://www.windows-api.com/microsoft/VB-WinAPI/31942873/find-the-login-time-of-the-current-windows-user.aspx

This gets the Logon time, and also adjusts for time zones (and probably Daylight Saving)



Sub test()
MsgBox LastLogon
End Sub


In module 1

Paul