formula to find file mod. date of exel file (2003)

Topic

New Reply

I have a request to find a way to get the file’s modification date.

Can’t seem to find anything that’s getting me there. Can someone give me a pointer?

Thanks
Jim

Reply | Quote

Replies

You would need to create a custom function for this:

Public Function GetSaveDate()
On Error Resume Next
GetSaveDate = ActiveWorkbook.BuiltinDocumentProperties(“Last Save Time”)
End Sub

You can then put this formula in a cell:

=GetSaveDate()

The On Error Resume Next avoids errors if the workbook has not been saved yet, or if the active document is not an Excel workbook.

Reply | Quote

Thanks!

Reply | Quote

Thanks!

Reply | Quote

You would need to create a custom function for this:

Public Function GetSaveDate()
On Error Resume Next
GetSaveDate = ActiveWorkbook.BuiltinDocumentProperties(“Last Save Time”)
End Sub

You can then put this formula in a cell:

=GetSaveDate()

The On Error Resume Next avoids errors if the workbook has not been saved yet, or if the active document is not an Excel workbook.

Reply | Quote