Open files with wildcards

[inajica]

I am running Excel 2007. I am trying to open some files using a wildcard. I have a folder and five subfolders and in these five subfolders I have a file in each of these five subfolders. The wildcard file would look like this "finishedresults*". I tried application.filesearch, but I don't think Excel 2007 support that object anymore. Any other ideas? Thanks.

[Bob Phillips]

No, but it supporst Dir, and that is similar

Dir "C:\test\finishedresults*.xls"

Doesn't do sub-directories though, so if you know their names, you will need to handle each.