Cross-Posted:

http://www.mrexcel.com/forum/showthread.php?p=2387212

Duplicate:
http://www.mrexcel.com/forum/showthread.php?t=483566

Reference to VBAX KB Article:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=1042

Reference to Application.FileSearch method:
http://www.automateexcel.com/2008/09...n-a-directory/


@Pedie:

Please see Here

Please read Mr. Puls' article in the above link. I cannot imagine a kindlier way of advising reference cross-posting; kudos to Ken.

I believe you mention working in 2007. .FileSearch was ditched in 2007. I would suggest you keep after xenou's suggestion, albeit, I would most likely go late-bound.

Mark