RE: count time

From: Mark Heyhoe (MarkHeyhoe_at_discussions.microsoft.com)
Date: 06/16/04 

Date: Wed, 16 Jun 2004 06:37:01 -0700

Why not just stick the open file and write time in workbooks auto_open sub and the close time in the auto_close sub?

Mark

"Mark" wrote:

> I looking for VBA code produce: write to file.txt working
> life workbook by user.
>
> I have only code with open file time:
>
> Open ThisWorkbook.Path & "\file.txt" For Append As #1
> Print #1, Now, Application.UserName,
> Application.ActiveWorkbook.Name
> Close #1
>
> How and where i write variable and remain code to show
> total time usage by one user?
>
> Regards
> Mark
>

Relevant Pages

  • Re: Soft Reset and Power Off
    ... On Windows CE keyb_event is in coredll.dll Also your P/Invoke should be ... Public Shared Sub keybd_event(ByVal bVk As Byte, ByVal bScan As Byte, ByVal ... the Soft Reset works perfectly! ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Save to default desktop
    ... Mark wrote: ... >> Sub SaveToDesktop1() ... >> Dim WSHShell As Object ... >> Dim DesktopPath As String ...
    (microsoft.public.excel.misc)
  • RE: Pop-up reminder on Forms??
    ... how do I mark a post as "Answered"? ... > Private Sub Form_BeforeUpdate ... >>> stay saved for a longer time, so other can benifit from it. ... >>> Good luck ...
    (microsoft.public.access.formscoding)
  • Re: Paste append to form dialogue work around
    ... I'd agree that your approach is better, Mark, but the Resume Next should ... Sub Test() ... "None of the field names you pasted onto the Clipboard match the field ... When I paste records from the clipboard to a form I've created. ...
    (microsoft.public.access.forms)
  • Re: Async thread not freeing up UI
    ... and yes the multicore architecture that AMD ... > as my Matrix_multiply sub is multiplying arrays. ... >> Hello Mark,,, ...
    (microsoft.public.dotnet.languages.vb)