Retrieve the date of another excel file

  • Thread starter Thread starter BRABUS
  • Start date Start date
B

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
 
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
 
Mike said:
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
Click to expand...



Thanks thats exactly what I needed
 
Back
Top