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?


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=480365

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)


"ceemo" wrote in
message ...

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?


--
ceemo
------------------------------------------------------------------------
ceemo's Profile:
http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=480365