Insert the date an Excel Workbook was last modified.

Anonymous
2010-11-17T00:13:29+00:00

Is there a way to insert, into a cell, the date that a workbook was last modified?

Perhaps by getting the modified date from the file's properties into a cell.

Thanks in advance.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2010-11-17T00:29:39+00:00

Hi,

To modify a workbook you have to save it so we can use the before_save event

ALY+F11 to open vb editor. Double click 'ThisWorkbook' and paste this code in on the right. Change the sheet and range to suit

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

Sheets("Sheet1").Range("A1").Value = Now

End Sub

If this post answers your question, please mark it as the Answer.

Mike H

Was this answer helpful?

100+ people found this answer helpful.
0 comments

86 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-02-28T16:01:10+00:00

    what i did to put the date into a cell was use the NOW function.

    It puts the current date and time into the cell.

    =NOW()

    cell

    2/28/2014 10:55

            What i was looking for was a way to put the persons name on the sheet who last modified in the sheet itself since we share it

    Was this answer helpful?

    0 comments
  2. Anonymous
    2014-01-17T06:36:18+00:00

    Thank You Chip - This helped right away in first go ... Was quite simple I must say.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2014-01-15T19:16:46+00:00

    GP2,

    I found a site that gave me the Modified date that I was looking for. Dinesh fix seemed to work for others, but unfortunately I could not get the #NAME? error to go away. Here is the link to the site:

    http://www.extendoffice.com/documents/excel/954-excel-created-last-modified-time.html I used VBA 2 and it worked. I hope this works for you.

    Maria

    Was this answer helpful?

    0 comments
  4. Anonymous
    2014-01-12T05:48:10+00:00

    Thanks, Dinesh, for the detailed instructions, but it did not work for me (using Excel 2010). I copied your code into the new "Module 1" under "Modules", saved the Excel file from within the VB window (I assume that is what you mean by "Save this file"?), then did "File, Close and Return to Microsoft Excel". When I start typing "= LastSaveDate" into a cell, the text populates automatically with the full LastSaveDate name (so it is present), but after I've hit Return the #NAME? error appears in the cell. Does anyone have any ideas where I'm going wrong? Just to agree with others, this is a very useful function that should be a standard function in Excel. Jon K

    I too was surprised to not find this functionality anywhere in Excel.

    This has been available in MS Word for years, and I definetly agree, it should be standard in Excel. After looking through every menu option (some more than once), i gave up then looked online. This is where I found your posted question and and the replies to it.

    I found many posts for this issue along with several replies, and yes, it seems like many feel this should be a built-in fucntion. There seemed to be several replies that were not helpful, along with a couple smart-**** answers.

    So would like to add to this.... by complimenting whetstonejon for his reply. It seems well written and extremely helpful. I'm not extremely familar with Excel, but maybe this user function (and any similar) can be maintained, in a common 'library' that any spreadsheet could access and use the functions, but that's for another post.

    Thank you again for your question and for the reply from whetstonejon.

    Also, thank you for your follow up about the Macro setting, that would have gave me a problem as well.

    Pete

    Was this answer helpful?

    0 comments