Excel to log name, date and time somebody accessed a report on a network drive....

[LittlegmoonBH]

Hi,

I’m looking for help logging in Excel, using VBA to log in ahidden sheet the username, date and time logged in and logged out of reports inshared locations.

I know a solution exists because I’ve used one before, but Ican’t for the life of me remember how I did it…

Does anybody have anything they could share? This isbasically for me to monitor how frequently reports produced are used, and bywho.

Thanks in advance for your help!

 

[Rijnsent]

Hi LittleegmoonBH,
you mean something like this: https://www.mrexcel.com/forum/excel-questions/1054647-vba-log-users-workbook_open-event.html ?
Cheers,
Koen

 

[LittlegmoonBH]

Hi Rijnsent,

Thanks for the response! I’ve tried this and it doesn’t work. It workedonce, but it’s not re-writing the 1^st row over and over.

 

[Rijnsent]

Hi LittlegmoonBH,
that macro runs every time the user opens the file. The only catch: the data is written to the log-sheet, but if the user doesn't save the file, the new line is not there anymore the next time you open the file. Plus: the user has to allow macros to log it, if they block macros it won't work.
Koen