Application.FileSearch is gone in Excel 2007 -- Alternatives

[SydneyGeek]

For those who use Application.FileSearch in Excel and Access, it's a huge pain that the object has been hidden in Office 2007.

I spent some time looking around for alternatives and have found two so far.

1. A FileSearch class that you can add to your project. Instead of using Application.FileSearch, you reference FileSearch instead

2. You can also use VBScript.

Has anyone else come up with a useful method that they can share with the Board?

Denis

 

[Richard Schollar]

Hi Denis

Along the lines of what Andrew suggested, this is a function using Dir that I posted at - shock horror! - Ozgrid:

http://www.ozgrid.com/forum/showpost.php?p=369573&postcount=4

 

[SydneyGeek]

Thanks Richard,

Good to have as many options as possible when you want to solve a problem.
Why the functionality was removed in the first place beats me...

Denis

 

[NateO]

Not sure why it was removed, might be because it was buggy...?

Here's something I came up with:

http://www.mrexcel.com/board2/viewtopic.php?p=1253882#1253882

 

[SydneyGeek]

Thanks Nate



Denis

 

[NateO]

You are welcome.

 

[iknowu99]

Hi People

I have been using this function extensively. Most my macros include the Application.FileSearch method.
Perhaps there is a way to automatically update? Maybe add References?
Thanks!

 

[iknowu99]

i am slowly adopting the function from ozgrid's: http://www.ozgrid.com/forum/showpost.php?p=369573&postcount=4

but what about subfolders??

 

[tr03bor]

i am slowly adopting the function from ozgrid's: http://www.ozgrid.com/forum/showpost.php?p=369573&postcount=4

but what about subfolders??

yep, what about subfolders? I need a code for this too!

 

[SydneyGeek]

Take a look at Nate's code on this page. It handles subfolders too.

Denis