DATE MODIFIED

Simon · Mar 25, 2010

Hi
I would like some code which places the "date modified" of an external
workbook into a cell.
Can anyone help,
Thanks
Simon

Jacob Skaria · Mar 25, 2010

'For date
Range("A3") = Datevalue(filedatetime("d:\sales.xls"))

'For date and time
Range("A3") = filedatetime("d:\sales.xls")