Tracking workbook usage

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
 
D

Dave Peterson

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.
 
G

Guest

No I can't find another share. Those folks have a read-only permission for a reason.
 
D

Dave Peterson

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
Tracking Changes in a non-shared workbook 1
Workbook_Open event not called when workbook forced to re-open in read-only mode. 2
Track Changes without sharing a workbook? 2
Changing the Path In a Usage Log 12
count time 7
Text file to measure file usage 4

Top