Last Save Date

[Fordbfilm]

Does anyone know how to automatically enter the last save date on Excel 2007
without creating a macro?

 

[Jacob Skaria]

You need to have a macro or a UDF. Try the below UDF

In any cell type the formula
=GetProperties("Last Save Time")

Function GetProperties(strType As String) As String
GetProperties = ThisWorkbook.BuiltinDocumentProperties(strType)
End Function


If this post helps click Yes