Word 2007 VBA- Application.filesearch

[herman7]

I have run into problem in Word 2007 with a macro I have used for years.

The macro uses the command
Application.Filesearch
..Lookin = "C:\Folder"

Application.Filesearch not available in the VBA shipped with Word 2007

MSDN website confirms this "Filesearch" property is not available with the
"Application" object. This can be verified by pressing period after
Application in a visual basic window.
What is the work around to get a list of all the files in a folder?
Thanks

Herman

 

[Shauna Kelly]

Hi Herman

The workaround is to go back to the 'old' way of doing it, using Dir. For
more information, see
http://www.word.mvps.org/FAQs/MacrosVBA/ReadFilesIntoArray.htm

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word

 

[Lee Scanlon]

Just got around to updating a macro that searches years of news files for a
string - orig. used application.filesearch

Nothing to say but thanks for this elegant solution. In fact Dir$ is a lot
less cumbersome anyway, isn't it?

Lee

url:http://www.ureader.com/msg/10226115.aspx