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

 

[vsrihari007]

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

Denis

Seems like Nate's link is inactive. It gives "Page not found"

Can you please re-point to or re-activate this page?

Thanks~H

 

[SydneyGeek]

It looks like most of the lnks on this page are dead.
I did another search for Filesearch class and found this page, with a fair bit of detail and a sample Access database to demonstrate its use.
The class aims to replicate the original Application.Filesearch so it should loop through subfolders.

Link: Download clFileSearch -- Class Module to Replace Office FileSearch Object

Denis

 

[Scott Huish]

Rumor was that Microsoft thought nobody used it.

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

 

[vsrihari007]

Rumor was that Microsoft thought nobody used it.

Thanks a lot for the immediate response. I guess it seems more than simple plug-it-in situation, calling for some more research. Will try and let the forum know...