View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alpineman2 Alpineman2 is offline
external usenet poster
 
Posts: 18
Default Help pLease... Creating a Usage Log

I am trying to create a usage log, below is the code:

Private Sub Workbook_Open()
Open ThisWorkbook.Path & "\usage.log" For Append As #1
Print #1, Application.UserName, Now
Close #1
End Sub

However, I don't know where the log is stored therefore am not sure if it is
working.
Would someone be able to help me?
Your guidance will be greatly appreciated.

Thank you,

J.B.