Retrieve the date of another excel file
 

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




--
BRABUS

Retrieve the date of another excel file
 

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" wrote:


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




--
BRABUS

Retrieve the date of another excel file
 

Mike H;2139648 Wrote:
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" wrote:
-

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




--
BRABUS
-



Thanks thats exactly what I needed.




--
BRABUS