Hi Paul/Friends, I would like to use this concept for my personal computer. I knew very well that It is going to be tough job but as many experts are part of this group, I hope someone would definitely try to get answer. Let me know if you need more information on same. Please find the attached sheet that can be use as start up sheet to solve the problem.
On Mon, Aug 13, 2012 at 7:41 PM, Paul Schreiner <schreiner_p...@att.net>wrote: > I've worked through quite a bit of this. > Spent MANY hours trying to work it out. > > There's LOTS of things to consider. > > #1.. is this for personal use, or for many people in an office? > 1a) If it is an office, is there an I.T. department that controls PC and > Windows configuration? > > Windows has a "Group Policy" that allows you to create login/logouts > scripts for Windows. > Since my work environment has an I.T. Department that controlls our system > configurations, > I could not utilize this method. (They locked out the Group Policy Editor) > > Instead, I created a login and logout VB script that writes to a text file. > It looks for today's date. > If found, it compares the current time to the time record. > If for some reason, the current time is EARLIER than the login time > recorded, it overwrites it. > (this should only happen if someone manually modified the file) > > This vbscript is placed in the Startup folder and runs when windows Starts. > > logOUT is a bit of a problem. > > I created a vbscript to use to log out. > It records the time, then exits windows. > > However, the user MUST use this script to log out. > If windows is exited normally, (or abnormally for that matter)... > basically.. if any other method is used to log out, the time is not > recorded. > > For Personal use, I am very disciplined about using this. > But for widespread use? I wouldn't trust it. > > Another security issue is that the file it updates is a simple text file. > Therefore, a user COULD modify the values... > (i.e.: I was 10 minutes late getting to my desk because my boss was > talking to me at the coffee machine on the way in. > So, I wanted to "back out" the time so it wouldn't show up as "late"...) > I've CONSIDERED trying to open the file as "Binary". > I've done this from Excel before, but not from VBScript. > > My excel file then updates from this log file when opened. > > > *Paul* > > ----------------------------------------- > *“Do all the good you can, > By all the means you can, > In all the ways you can, > In all the places you can, > At all the times you can, > To all the people you can, > As long as ever you can.” - John Wesley > *----------------------------------------- > > > ------------------------------ > *From:* David Grugeon <da...@grugeon.com.au> > *To:* excel-macros@googlegroups.com > *Sent:* Mon, August 13, 2012 9:25:56 AM > *Subject:* Re: $$Excel-Macros$$ Need your help > > Magnesh and Paul > > I think you could put an excel file (or a shortcut to one), in the startup > folder. have an on open macro in the sheet to record the opening time. > Then have a before close macro to record the time and save itself. > > My only concern would be whether Windows kills excel before the saving > process is complete. Otherwise it should work, provided you don't mind > having the file, and excel, open all day. > > On 13 August 2012 22:55, Paul Schreiner <schreiner_p...@att.net> wrote: > >> This is going to be a tough one. >> It involves access to the Windows environment. >> I REALLY hope someone has an alternative, >> but I think you're going to have to write some >> VBscript files that run at Windows Login and Logout >> that will make entries to a log file. >> >> >> *Paul* >> >> ----------------------------------------- >> *“Do all the good you can, >> By all the means you can, >> In all the ways you can, >> In all the places you can, >> At all the times you can, >> To all the people you can, >> As long as ever you can.” - John Wesley >> *----------------------------------------- >> >> >> ------------------------------ >> *From:* Mangesh Vimay <mangesh.da...@gmail.com> >> *To:* excel-macros@googlegroups.com; NOORAIN ANSARI < >> noorain.ans...@gmail.com>; rajan verma <rajanverma1...@gmail.com> >> *Sent:* Mon, August 13, 2012 8:48:16 AM >> *Subject:* $$Excel-Macros$$ Need your help >> >> Hi Friends, >> >> Please help me on issue below. >> *Issue :-* I need such excel file which can automatically stored login >> time with date and logout time so that I could able to analysis for how >> much time my computer was switched on/in use. >> For example, >> If I login by the time *7:00:00 AM* and logout on *12:30:00 PM* on Date * >> 13/8/2012*. >> Then it should feed all these data in an excel sheet like as - >> [image: Inline image 1] >> >> We can take help of VBA also. >> I hope I am able to tell you my need. If not please let me know. >> Thanks in advance. >> >> -- >> With regards, >> >> MaNgEsH >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com. >> >> >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com. >> >> >> > > > > -- > Regards > David Grugeon > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > -- With regards, MaNgEsH -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
<<image.png>>
Login_Logout.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
