Yes, after discussing with you this query is resolved. Thanks for your concern rajan. All the best !!!
Regards Lokesh.M On Mon, Jan 9, 2012 at 6:55 PM, Rajan_Verma <rajanverma1...@gmail.com>wrote: > 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 > -- 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
