Last Save Date

F

Fordbfilm

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

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
 
Top