Tracking workbook usage

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to track who opens a certain excel workbook. The macro below works great but only for those who have read/write permissions. It doesn't track users that have read-only permissions. Any ideas on what I need to do? Thank you

Private Sub Workbook_Open(

Open ThisWorkbook.Path & "\TrackUsage.log" For Append As #
Print #1, Application.UserName, Now, "Opened
Close #

End Su
 
They don't have write permissions to the common share, so they can't update the
..log file???

Can you find a common share that's open somewhere?

Maybe you could use that instead.
 
If they can send emails, maybe you could do something that way.

Ron de Bruin has lots of sample code for working with email at:
http://www.rondebruin.nl

(But I don't know if this would be transparent all the time.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

workbook directory where is it? 4
Help pLease... Creating a Usage Log 2
Track Changes without sharing a workbook? 2
Tracking Changes in a non-shared workbook 1
count time 7
Changing the Path In a Usage Log 12
Workbook_Open event not called when workbook forced to re-open in read-only mode. 2
Cannot save macro spreadsheet due to ReadOnly = True 1

Back
Top