Application.FileSearch is gone in Excel 2007 -- Alternatives

SydneyGeek · Jun 24th, 2007, 05:02 AM

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

RichardSchollar · Jun 24th, 2007, 08:54 AM

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...73&postcount=4

SydneyGeek · Jun 24th, 2007, 01:26 PM

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 · Jun 25th, 2007, 12:38 AM

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

Here's something I came up with:

http://www.mrexcel.com/board2/viewto...253882#1253882

SydneyGeek · Jun 25th, 2007, 01:14 AM

Thanks Nate

Denis

NateO · Jun 25th, 2007, 01:51 AM

You are welcome.

iknowu99 · Aug 13th, 2008, 07:38 PM

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 · Aug 13th, 2008, 07:43 PM

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

but what about subfolders??

tr03bor · Sep 10th, 2008, 10:41 AM

Quote:

Originally Posted by iknowu99

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

but what about subfolders??

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

SydneyGeek · Nov 17th, 2008, 03:44 AM

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

Denis

Jun 24th, 2007, 08:54 AM	#2
RichardSchollar MrExcel MVP Moderator Contortionist Join Date: Apr 2005 Location: Hampshire, UK (Home); London, UK (Work) Posts: 18,983	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...73&postcount=4 __________________ Richard Schollar Microsoft MVP - Excel Need to post some data? PM me with your email address for the Beta version of the Board html maker!

Jun 24th, 2007, 01:26 PM	#3
SydneyGeek MrExcel MVP Join Date: Aug 2003 Location: Sydney, Australia Posts: 9,204	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 __________________ Self-preservation: For when you've got yourself in a jam ------------------------------------------------------ My site contains a number of Excel and Access Resources

Jun 25th, 2007, 12:38 AM	#4
NateO MrExcel MVP Admin Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,635	Not sure why it was removed, might be because it was buggy...? Here's something I came up with: http://www.mrexcel.com/board2/viewto...253882#1253882 __________________ Regards, Nate Oliver Microsoft Excel MVP Nate's Excel Blog

Jun 25th, 2007, 01:14 AM	#5
SydneyGeek MrExcel MVP Join Date: Aug 2003 Location: Sydney, Australia Posts: 9,204	Thanks Nate Denis __________________ Self-preservation: For when you've got yourself in a jam ------------------------------------------------------ My site contains a number of Excel and Access Resources

Jun 25th, 2007, 01:51 AM	#6
NateO MrExcel MVP Admin Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,635	You are welcome. __________________ Regards, Nate Oliver Microsoft Excel MVP Nate's Excel Blog

Jun 24th, 2007, 05:02 AM	#1
SydneyGeek MrExcel MVP Join Date: Aug 2003 Location: Sydney, Australia Posts: 9,204	Application.FileSearch is gone in Excel 2007 -- Alternatives 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 __________________ Self-preservation: For when you've got yourself in a jam ------------------------------------------------------ My site contains a number of Excel and Access Resources

Aug 13th, 2008, 07:38 PM	#7
iknowu99 Join Date: Dec 2004 Location: PA Posts: 925	Re: Application.FileSearch is gone in Excel 2007 -- Alternatives 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! __________________ Hence, we fail to reject the null hypothesis that there is no relationship

Aug 13th, 2008, 07:43 PM	#8
iknowu99 Join Date: Dec 2004 Location: PA Posts: 925	Re: Application.FileSearch is gone in Excel 2007 -- Alternatives i am slowly adopting the function from ozgrid's: http://www.ozgrid.com/forum/showpost...73&postcount=4 but what about subfolders?? __________________ Hence, we fail to reject the null hypothesis that there is no relationship

Nov 17th, 2008, 03:44 AM	#10
SydneyGeek MrExcel MVP Join Date: Aug 2003 Location: Sydney, Australia Posts: 9,204	Re: Application.FileSearch is gone in Excel 2007 -- Alternatives Take a look at Nate's code on this page. It handles subfolders too. Denis __________________ Self-preservation: For when you've got yourself in a jam ------------------------------------------------------ My site contains a number of Excel and Access Resources

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode