+ Reply to Thread
Results 1 to 2 of 2

Log/Record every user of a workbook

  1. #1
    Forum Contributor
    Join Date
    09-02-2013
    Location
    London
    MS-Off Ver
    Excel 2019
    Posts
    368

    Log/Record every user of a workbook

    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.

  2. #2
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    575

    Re: Log/Record every user of a workbook

    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:

    Please Login or Register  to view this content.
    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.
    Last edited by BellyGas; 08-16-2017 at 06:00 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Limit User record views
    By Zachraeth in forum Access Tables & Databases
    Replies: 18
    Last Post: 08-23-2013, 02:08 PM
  2. [SOLVED] Macro to record User Name and Duration user accessed file.
    By bajdr47 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2013, 04:14 PM
  3. Edit Record from User Form
    By bwilliamsuncc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-12-2012, 07:01 PM
  4. filtering out a record for each user
    By dhariniu in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-26-2012, 08:23 AM
  5. [SOLVED] Record the user ID when entering Data in row.
    By bajdr47 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-21-2012, 06:08 PM
  6. each user has one month record
    By stoey in forum Access Programming / VBA / Macros
    Replies: 7
    Last Post: 08-21-2012, 12:12 PM
  7. Add next record using user form
    By rajeev.raj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-26-2010, 02:15 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1