Excel: How can I add "Last Modified" to Excel

Terry Seagert 101 Reputation points
2021-11-02T13:44:49.91+00:00

Excel: How can I add "Last Modified date" in a cell on an Excel spreadsheet every time I save it? Office 2019

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,500 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,641 questions
0 comments

13 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom van Stiphout 1,621 Reputation points MVP
    2021-11-07T19:25:19.087+00:00

    double-click to open the module (as I wrote in first instance).

    0 comments
  2. Terry Seagert 101 Reputation points
    2021-11-07T19:36:39.367+00:00

    As this:
    147053-save.jpg

    0 comments
  3. Terry Seagert 101 Reputation points
    2021-11-07T19:55:54.197+00:00

    Or Like this

    147054-orlike.jpg

    0 comments
  4. Terry Seagert 101 Reputation points
    2021-11-07T19:55:54.197+00:00

    Or Like this

    147054-orlike.jpg

    0 comments
  5. S Z 0 Reputation points
    2023-02-02T04:09:58.81+00:00

    hi Terry. not sure if you have fixed the issue.

    correct codes are:

    Private Sub Workbook_Open()

    Range("C1").Value = FileDateTime("file path")

    End Sub

    file path = C:.....desktop

    do not include worksheet name in file path

    0 comments