ExcelBanter - DATE MODIFIED

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - DATE MODIFIED (https://www.excelbanter.com/excel-programming/441012-date-modified.html)

Simon

DATE MODIFIED

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

DATE MODIFIED

'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

All times are GMT +1. The time now is 12:41 AM.