+ Reply to Thread
Results 1 to 3 of 3

Last Saved by & Time & date in cell

  1. #1
    Registered User
    Join Date
    11-24-2007
    Location
    Florida
    MS-Off Ver
    Various
    Posts
    64

    Last Saved by & Time & date in cell

    Hello

    I'm looking for a way show the username of the person who last saved the spreadsheet, and the date & time it was saved. I would like to be able to ouput this data in certain cells on the worksheet. Is this possible?

    I have tried using something like:

    Please Login or Register  to view this content.
    But for some reason this displays the current data and not whoever last saved it. Also could not find a "Last Save Date" option.

    Any help appreciated.
    Last edited by Xaos; 07-20-2009 at 06:28 PM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Last Saved by & Time & date in cell

    As long as you're writing code anyway, you could store the username (from Environ) and date in workbook names variables or on a hidden sheet in the BeforeSave event.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    11-24-2007
    Location
    Florida
    MS-Off Ver
    Various
    Posts
    64

    Re: Last Saved by & Time & date in cell

    This is exactly what I ended up doing. thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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