Sumesh, I don't intend to get your hopes up... ok.. yes I do... but I've been playing with my VBA script that looks at the Event Logs.
What I'm doing right now is trying to "interpret" what log entry is made when an event occurs. for instance, I want to know when a user: Logs in, Lock Windows Unlocks Windows Logs Out The problem is that there seems to be an 'event code' that has to be used in combination with a "Login Type" They bury the Login Type in a message string, but I just found it in an array. I'm close... very close. In a little while, I'll post what I have so you can give it a go... Paul ________________________________ From: SumesH P S <sumesh.subbay...@gmail.com> To: excel-macros@googlegroups.com Sent: Sat, December 5, 2009 3:29:11 AM Subject: Re: $$Excel-Macros$$ Time Tracker Yes Paul, what you mentioned is correct I have to pull that information Thanks Sumesh On Wed, Dec 2, 2009 at 11:18 AM, SumesH P S <sumesh.subbay...@gmail.com> wrote: Hi All, > > >Could you please help me to write a macro for saving the date and time in a >spread sheet when the user lock the system, when the user open it also has to >be captured. > > >Many thanks for your help > > >Kind regards >Sumesh-- >---------------------------------------------------------------------------------- >Some important links for excel users: >1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >http://www.excelitems.com >2. Excel tutorials at http://www.excel-macros.blogspot.com >3. Learn VBA Macros at http://www.vbamacros.blogspot.com >4. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > >To post to this group, send email to excel-macros@googlegroups.com >If you find any spam message in the group, please send an email to: >Ayush Jain @ jainayus...@gmail.com or >Ashish Jain @ 26may.1...@gmail.com ><><><><><><><><><><><><><><><><><><><><><><> >HELP US GROW !! > >We reach over 6,500 subscribers worldwide and receive many nice notes about >the learning and support from the group. Our goal is to have 10,000 >subscribers by the end of 2009. Let friends and co-workers know they can >subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
