modified date

[ceemo]

hi all,

Is it possible to check the modified date/time of either an xls or csv
file on a floppy disk and then execute a module if the modified
date/time is within a certain time frame?

 

[Bob Phillips]

You can use FileDateTime

Ans = filedatetime ("C:\mytest\volker1.xls")
If Date - DateValue(ans) < 10 Then 'less than 10 days old
myMacro
...

--

HTH

RP
(remove nothere from the email address if mailing direct)