Log/Record every user of a workbook

**rakotonirinas** · 08-16-2017, 05:23 AM

Hello specialists and professionals,

Once again, I need your kind help and suggestion.

I am trying to write a vba code where every time a workbook has been saved with new data in, it will also log the name of that user and the time in which the new save was performed.

So, as an example:

If I, updated the workbook yesterday at 2:15pm, then on one worksheet it will have my name followed by the date and the time.
When someone else then modify the workbook and save it, let's say at 11:40 am today, then that person lame will be listed below my name with the date and time stamp when it was saved.

Do you think this is achievable through vba? I would appreciate your help if there is a possibility to write up a code for this.

Ultimately, the purpose of the vba here is to automate that recording process by preventing the action of doing it manually but particularly forgetting that log as well.

Thank you for your consideration and help.

**BellyGas** · 08-16-2017, 05:41 AM

No problem.

Where do you want the log of who's done what and is there any need for user security to prevent people from manually editing the log?

To identify who has opened the workbook:


Public Function requestor(q As Integer) As String
    Set objAD = CreateObject("ADSystemInfo")
    Set objUser = GetObject("LDAP://" & objAD.Username)
    requestor = objUser.DisplayName
End Function

This will pull the network user name (full name, not UID). You can reference this by putting "=requestor(1)" into any cell on any worksheet.

Then, in the thisworkbook module put code to log this somewhere using the before_close event.

Log/Record every user of a workbook

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Log/Record every user of a workbook

Re: Log/Record every user of a workbook

Thread Information

Users Browsing this Thread

Similar Threads

Limit User record views

[SOLVED] Macro to record User Name and Duration user accessed file.

Edit Record from User Form

filtering out a record for each user

[SOLVED] Record the user ID when entering Data in row.

each user has one month record

Add next record using user form

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions