Retrieve the date of another excel file

[BRABUS]

Please can someone show me (in an idiots format) what I need to do to
show the last saved date of a different excel file that I provide the
name and file location of in one cell in my current spreadsheet and
then show it in a cell on this same spreadsheet.

Thanks
Rob

 

[Guest]

This macro takes a path and filename from A1 and writes the date and time of
the last modification to A2

Sub getthedate()
filedate = FileDateTime(Worksheets("Sheet1").Cells(1, 1).Value)
Worksheets("Sheet1").Cells(2, 1).Value = filedate
End Sub

Mike

 

[BRABUS]

This macro takes a path and filename from A1 and writes the date an
time of
the last modification to A2

Sub getthedate()
filedate = FileDateTime(Worksheets("Sheet1").Cells(1, 1).Value)
Worksheets("Sheet1").Cells(2, 1).Value = filedate
End Sub

Mike

:
-

Please can someone show me (in an idiots format) what I need to do to
show the last saved date of a different excel file that I provide the
name and file location of in one cell in my current spreadsheet and
then show it in a cell on this same spreadsheet.

Thanks
Rob

Thanks thats exactly what I needed