Office 2007 - application.filesearch missing for VBA

[suzupis]

I have several macros written for excel which use the application.filesearch
method to retrieve files within a directory. It appears that Office 2007 no
longer supports this. Any suggestions on how to replace this code?

 

[Bob Buckland ?:-\)]

Hi Suzupis,

You may want to post also post this in the MS Excel newsgroup through the link below.

File=>Search is no longer in MS Office with the 2007 edition. The Office team has relinquished responsibilities for search back to
the Windows team.

You may want to include a code snippet when posting in the Excel group along with information on what your goal is in searching.
There may be an alternative approach that will work for you.
========
I have several macros written for excel which use the application.filesearch
method to retrieve files within a directory. It appears that Office 2007 no
longer supports this. Any suggestions on how to replace this code?>>
--
Please let us know if this has helped,

Bob Buckland ?
MS Office System Products MVP

LINKS
A. Specific newsgroup/discussion group mentioned in this message:
news://msnews.microsoft.com/microsoft.public.excel
or via browser:
http://microsoft.com/communities/newsgroups/en-us/?dg=microsoft.public.excel

B. MS Office Community discussion/newsgroups via Web Browser
http://microsoft.com/office/community/en-us/default.mspx
or
Microsoft hosted newsgroups via Outlook Express/newsreader
news://msnews.microsoft.com

 

[Harlan Grove]

Bob Buckland ? (At Beautiful Downtown) wrote...
....

You may want to include a code snippet when posting in the Excel group along with
information on what your goal is in searching.
There may be an alternative approach that will work for you.

....

Use Windows Script Host's FileSystemObject, but it's not quite the
same, and if the OP is taking advantage of XL11 and priors' ability to
index .xls files, there isn't comparable OS functionality in Wndows XP,
so unlikely in any previous Windows version.

Is anyone on any of the Office app teams ever going to publish a
deprecated features list?