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

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


--
Jacob


"Simon" wrote:

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