PDA

View Full Version : Open files with wildcards



inajica
06-01-2008, 08:10 AM
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
06-01-2008, 09:56 AM
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.