modified date

[Guest]

Is there a way to have a cell report the date the file was last modifed? Thanks in advance.

 

[Mark W.]

Look at the Excel Help topic for "View information about changes to a workbook".

 

[Ivan F Moala]

On 2002-03-12 12:53, Anonymous wrote:
Is there a way to have a cell report the date the file was last modifed? Thanks in advance.

'This UDF may help

Function FileLastMod() As String
Dim FileDate As Double

On Error Resume Next
FileDate = FileDateTime(ThisWorkbook.FullName)
If Err.Number = 0 Then
FileLastMod = Format(FileDate, "dd/mm/yy hh:mm:ss")
Else
FileLastMod = "Error"
End If
End Function


'Place in a Module and call from worksheet as follows

'=FileLastMod()



ivan



Ivan