You could use application.filesearch. But that goes away in xl2007--and it's
kind of flakey in earlier versions.

Ron de Bruin has converted many of his sample macros to use FSO
(FileSystemObject). It seems to work fine for him (and others <bg).

http://www.rondebruin.nl/fso.htm

Barb Reinhardt wrote:

Let's say I have a directory structure like this:

FOLDER1
FOLDER 1A
FOLDER 1A1
FOLDER 1A2
FOLDER 1B
FOLDER 1B1
FOLDER 1B2

I want to be able to select a high level folder and then open all XLS
workbooks that are in every folder below it. I'm not even sure how to begin
with this.

Also, I think I've seen somewhere that there's a way to allow the user to
CANCEL during execution of a macro. How do I do that?

Thanks in advance,
Barb Reinhardt

--

Dave Peterson