F Fordbfilm Jun 24, 2009 #1 Does anyone know how to automatically enter the last save date on Excel 2007 without creating a macro?
Does anyone know how to automatically enter the last save date on Excel 2007 without creating a macro?
J Jacob Skaria Jun 24, 2009 #2 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
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
