Hello
Can anyone help me read details about a current workbook.
Bascally everytime an excel spreadsheet is opened I want to saved the last modified date to say Sheet1.range("A1")
Thank you in advance.
Hey man,
The Workbook has a property named 'BuiltinDocumentProperties' that you can use to get pieces of information about the document. One of these is the Last Save Time
Cells(1, 1) = ActiveWorkbook.BuiltinDocumentProperties(12)
12 is the last saved time property. This will return an error is the workbook hasn't been saved.
can this be done with a UDF instead?
i've this so far:
Function FileSavedTime(w As Workbook) As Date
FileSavedTime = w.BuiltinDocumentProperties("Last Save Time")
End Function
