What do you use instead of the missing Application.FileSearch?
Thanks
John

Ron de Bruin shares some alternatives he

http://www.rondebruin.nl/fso.htm
and
http://www.rondebruin.nl/copy3.htm

On 05/13/2010 18:13, John wrote:
What do you use instead of the missing Application.FileSearch?
Thanks
John

Hi John,

Have a look at RoyUK's example: 'Excel 2007 Filesearch'
(http://excel-it.com/Excel%202007/2007_filesearch.htm)

hth
Rob


--
broro183

Rob Brockett. Always learning & the best way to learn is to
experience...
------------------------------------------------------------------------
broro183's Profile: http://www.thecodecage.com/forumz/member.php?u=333
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=202700

http://www.thecodecage.com/forumz

There are several approaches to this in this discussion:
http://social.msdn.microsoft.com/For...2-03f7994369d6
I lean toward the use of the file system object (FSO) generally, although
jpschmit puts up a nice solution. Search for jpschmit on the page to find
his post quickly.



"John" wrote:

What do you use instead of the missing Application.FileSearch?
Thanks
John
.

thanks. I made do using dir. Had forgotten about that.
JOhn

Dave Peterson wrote:
Ron de Bruin shares some alternatives he

http://www.rondebruin.nl/fso.htm
and
http://www.rondebruin.nl/copy3.htm

On 05/13/2010 18:13, John wrote:
What do you use instead of the missing Application.FileSearch?
Thanks
John