Is there a date property for a file found by DIR? How do I specify that I
want only files before a certain date?



"Gary Brown" wrote:

You need to use a recursive DIR( ).
Check out Mr Excel's...
http://www.mrexcel.com/forum/showthr...=recursive+dir

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Stratuser" wrote:

I need code that will look at all the files in a subdirectory and loop
through just the ones that are older than the first of the current month,
operating on them one at a time. I used to do this with the FileSearch
command, but that's gone in Excel 2007. How could I do it now?

Thanks for your help.