MrExcel Publishing
Your One Stop for Excel Tips & Solutions

linking the modified date in Excel


Posted by Mark Abshire on November 14, 2001 6:25 PM

How can I link the modified date of a file(last date file was saved)to a cell in the worksheet?


Posted by faster on November 15, 2001 5:41 AM

You can use a function. Paste the code in a module in
your workbook.

Function LModDate()
LModDate = ActiveWorkbook.BuiltinDocumentProperties(11)
End Function

The function will be available using
the function wizard in User Defined. Or once the
function is in your workbook paste the following into
the cell you need. Be sure to use a date format with
the cell.

=LModDate()