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