atusBar = False
End Function
Function GetTime(sWmiDate)
'Pass in a WMI date like "20091221114144.00-300"
'Returns in military hour:min:sec format, with hours from 0 to 23.
GetTime = Mid(sWmiDate, 9, 2) & ":" & Mid(sWmiDate, 11, 2) & ":"
le while, I'll post what I have so you can give it a go...
Paul
From: SumesH P S
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 t
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 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 a
From: Chechu
To: MS EXCEL AND VBA MACROS
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 S
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
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 t
