| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Last Date Modified | Excel Worksheet Functions | |||
| date that a row is modified | Excel Discussion (Misc queries) | |||
| date modified | Excel Discussion (Misc queries) | |||
| Modified Date | New Users to Excel | |||
| Last Modified Date | Excel Programming | |||
Hybrid Mode
