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
    2013-05-10T07:52:41+00:00

    Hello, the macro works but the date is wrong (2006 instead 2013) .

    what could be the reason?

    tks

    Was this answer helpful?

    0 comments
  2. Anonymous
    2013-03-08T20:15:21+00:00

    I am trying to use the vba code below as well:

    Function LastSaveDate()

        Application.Volatile True

        LastSaveDate = FileDateTime(ThisWorkbook.FullName)

    End Function

    You can call this from a cell with

    =LastSaveDate()

    and I keep getting a #NAME? error whenever I put =LastSaveDate() into the cell that I want the timestamp to be.

    Anybody know why this is occurring?

    Was this answer helpful?

    0 comments
  3. Anonymous
    2013-03-08T13:02:08+00:00

    I did the same thin as Chip Pearson suggested but I got #NAME? error when i typed =LastSaveDate()   in A1.

    any help??

    Was this answer helpful?

    0 comments
  4. Anonymous
    2013-02-27T17:19:46+00:00

    This works great with local files, but I tried getting the FileDateTime from a file on a SharePoint site in my company and it failed with "Invalid procedure call or argument".

    Any other suggestions?

    Was this answer helpful?

    0 comments