application.filesearch not working in excel 2007

**johnjohns** · 12-20-2009, 09:22 AM

I wrote a macro to list all the excel files from a directory and its sub-directories to an excel sheet. It is working in excel 2003 but shows error (object does not support this action) in 2007. Actually I have copied almost this entire macro from excel 2007 help only. Can somebody modify this to use in both the versions of excel?

Please Login or Register  to view this content.

Error occurs at the line

Please Login or Register  to view this content.

**stanleydgromjr** · 12-20-2009, 09:37 AM

johnjohns,

Application.FileSearch is not available in Excel 2007

See:
http://www.mrexcel.com/forum/showthr...ht=fList%28%29

http://www.ozgrid.com/forum/showpost...73&postcount=4

http://www.thecodecage.com/forumz/ex...directory.html

**johnjohns** · 12-20-2009, 09:52 AM

Thank you Stanly

But is this compensated in 2007 in any other way? Then perhaps I can use a version cheking and use the macro for 2003 and 2007. Any help is highly apreciated

rgds

johnjohns

**royUK** · 12-20-2009, 10:10 AM

This is what I use

http://excel-it.com/Excel%202007/2007_filesearch.htm

**johnjohns** · 12-21-2009, 01:12 AM

Thank you Roy!

A similar solution I got from Mr John Walkenbach's book also. But both these are not searching into sub directories. I think in 2007 macro side is not at all improved from 2003 and many features are missing also

regards

johnjohns

**teylyn** · 12-21-2009, 04:15 AM

Here's a link to another tool from smurf, but it's not free

http://www.codematic.net/excel-tools...filesearch.htm

**johnjohns** · 12-21-2009, 05:22 AM

Thanks a lot, all you wonderful people in this forum! Thanks for those immediate responses. Hope Microsoft may solve this issue in excel 2010 (I have not tried the beta version also yet). Or as Tylyn suggested I may go for a third party utility. Thank you all!

Warm regards

johnjohns