VBA Code for "Last Created" file saved in same location as workbook

[surkdidat]

In my folder, I have a tracker, and also a sheet that is saved down manually every hour which feeds and updates the main tracker.

The tracker, is called "Tracker" and the feed in extract, is called "Extract"

I am trying to find a solution to display the date and time it was last updated.

I am wondering if there is a way of referencing the Extract sheet that is saved down, and use the timestamp where it was created to display in a cell.

The cell would need (ideally) to be updated automatically (rather than having to click in and update)

I have found module code that saves the date and time (manually) of the last saved date of the current workbook, and don't know if there is a way of modifying this at all?

Function LastSavedTimeStamp() As Date
  LastSavedTimeStamp = ActiveWorkbook.BuiltinDocumentProperties("Last Save Time")
End Function

 

[I_know_nuffin]

in the Extract sheet add some code into the workbook Aftersave event to update the Tracker

 

[Armstrong_N14]

Function LastSavedTimeStamp()

LastSavedTimeStamp = FileDateTime(Range("A1").Value)

End Function


Cell A1 should contain the path where the file is saved

C:\Users\username\Documents\Tracker.xslm