HI Lokesh is your query resolved?
Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Lokesh Loki Sent: Jan/Sat/2012 07:01 To: excel-macros@googlegroups.com Subject: Re: Fwd: $$Excel-Macros$$ User login and logout time Thank you very much rajan. really i am appreciating your smartness. Regards Lokesh On Fri, Jan 6, 2012 at 8:59 PM, Rajan_Verma <rajanverma1...@gmail.com> wrote: Hi Lokesh, I am attaching Two files here.. 1). Save Access file at Shared Location. 2). In Code Module Replace Thisworkbook.Path with shared Path 3). Fill AllEmpID table in Database with EMPID for validation. ObjConnection.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & ThisWorkbook.Path & "\table.accdb" & ";" Regards Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Lokesh Loki Sent: Jan/Thu/2012 07:48 To: excel-macros@googlegroups.com Subject: Re: Fwd: $$Excel-Macros$$ User login and logout time ya he is attending my query and will informed to me soon. thanks for your valuable concern. regards lokesh.M On Thu, Jan 5, 2012 at 7:45 PM, Paul Schreiner <schreiner_p...@att.net> wrote: Sorry, the thread didn't include previous posts, so I thought you were the ORIGINATOR saying that you are waiting for someone to respond to your query. Instead, you were asking if he got the reply and did he find a solution. sorry for the misunderstanding... (on a personal note, if he DID find a solution, I'd sure like to find out what it is!) 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: Lokesh Loki <lokeshsmg2...@gmail.com> To: excel-macros@googlegroups.com Sent: Thu, January 5, 2012 8:40:06 AM Subject: Re: Fwd: $$Excel-Macros$$ User login and logout time No, i am not disagree with the reply what i have received from you. just i am waiting for the reply to the concerned person. Thanks a lot for your valuable concern. Regards lokesh.M On Thu, Jan 5, 2012 at 7:03 PM, Paul Schreiner <schreiner_p...@att.net> wrote: What kind of reply are you looking for? Do you disagree with the repy you received? 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: lokesh <lokeshsmg2...@gmail.com> To: excel-macros@googlegroups.com Sent: Thu, January 5, 2012 5:55:47 AM Subject: Fwd: $$Excel-Macros$$ User login and logout time Hi all, Still i am not getting any reply from you, please do the needful. regards lokesh.M ---------- Forwarded message ---------- From: Paul Schreiner <schreiner_p...@att.net> Date: Jan 3, 6:46 pm Subject: $$Excel-Macros$$ User login and logout time To: MS EXCEL AND VBA MACROS This may SEEM like a simple request, but it is WAY too involved to complete simply. There a MANY, MANY questions that need to be answered in order to BEGIN. First of all, Network Administrators can easily create reports of this type of activity. The Windows Authentication process logs each network connection request and termination. (they may not be KEEPING these logs, which could be requested) If (as in my company) the Network Admin people do not wish to SHARE this information, it IS possible to interrogate the PC's Event logs and attempt to locate the necessary events. But this is done on each workstation. If the users log into different workstations, and you wish to pull the information from these machines, you will have to have Admin privileges on each machine. There are software packages, both Free and can be purchased, that can do this nicely. However, the software must be run by someone with Admin privileges. A somewhat simpler approach to collect the data beginning NOW is to create login/logout procedures/scripts for the environment. These are standard scripts that are created by Network Admins and execute whenever a user logs in or out. It's possible that your company already has these, and it would be a matter of adding a few lines of code that would append the necessary info to a text file that you could interrogate. Again, it requires the cooperation of the Network Administrator(s). 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: lokesh <lokeshsmg2...@gmail.com> To: excel-macros@googlegroups.com Sent: Tue, January 3, 2012 5:01:13 AM Subject: $$Excel-Macros$$ User login and logout time Hi Rajan, Please see the attached excel mail and i want the mentioned user names login time and logout time based on their employee ID's. Please do the needful, if you have any concern please leave me a msg. Regards Lokesh.M-- FORUM RULES (934+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- --------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com