Can I insert a date function that will calculate the last edited or modified date?
K KTK Jun 27, 2005 #1 Can I insert a date function that will calculate the last edited or modified date?
B Bob Phillips Jun 27, 2005 #2 Try a UDF like Function DocProps(prop As String) On Error GoTo err_value DocProps = ActiveWorkbook.BuiltinDocumentProperties(prop) Exit Function err_value: DocProps = CVErr(xlErrValue) End Function Called with =DocProps("Last save time")
Try a UDF like Function DocProps(prop As String) On Error GoTo err_value DocProps = ActiveWorkbook.BuiltinDocumentProperties(prop) Exit Function err_value: DocProps = CVErr(xlErrValue) End Function Called with =DocProps("Last save time")
