Nope.
The question is:
A user turns on the computer, and logs in.
There are event logs that track the date/time the user logs in.
then, at some point during the day, the user takes a break and locks
his PC.
The event log records this also.
the user returns from break and unlocks the machine
(Yet another event log)
At the end of the day, the user logs off.
(one final event log entry)
Now, what we'd like to do is open an excel file and have
it load the events from the log tell us how long the user was logged in.
or something similar.
right?
Paul
________________________________
From: Chechu <cecic...@hotmail.com>
To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
Sent: Thu, December 3, 2009 2:39:50 PM
Subject: Re: $$Excel-Macros$$ Time Tracker
Not sure if I am correctly understanding the request here, but.... I
use the following code in some of my tools to track users usage:
Sub Auto_Open()
Dim serverfile As String
serverfile = "\\org\public\Hittrk\history.txt"
On Error Resume Next
Dim str As String
str = Application.UserName
str = str + "," + ActiveWorkbook.Name
str = str + "," & Now()
If Dir("\\org\public\Hittrk\", vbDirectory) = "" Then
MkDir ("\\org\public\Hittrk\")
End If
Open serverfile For Append As #1
Write #1, str
Close #1
'To force auto-calculations "ON"
With Application
.Calculation = xlAutomatic
.MaxChange = 0.001
End With
ActiveWorkbook.PrecisionAsDisplayed = False
End Sub
On Dec 3, 2:43 pm, Paul Schreiner <schreiner_p...@att.net> wrote:
> I've struggled with this one for several years.
> I finally did come across a VBS (Visual Basic Script) version that
> could generate a report and clear the log files.
> but I haven't been able to migrate it to Excel VBA.
>
> I was kind-of hoping that your post would get some responses
> and I wouldn't have to go through the exercise.
>
> When I get a "spare" minute, I'll try to re-visit my earlier attempt
> and see if I can get it cleaned up.
>
> Or, perhaps someone else has already done it??
>
> Paul
>
> ________________________________
> From: SumesH P S <sumesh.subbay...@gmail.com>
> To: excel-macros@googlegroups.com
> Sent: Wed, December 2, 2009 12:48:07 AM
> Subject: $$Excel-Macros$$ Time Tracker
>
> 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
> athttp://www.excelitems.com
> 2. Excel tutorials athttp://www.excel-macros.blogspot.com
> 3. Learn VBA Macros athttp://www.vbamacros.blogspot.com
> 4. Excel Tips and Tricks athttp://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 athttp://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
