How do you do a file search in XL2007

[raymond.allan]

Hi,

Windows XP Home sp2 and Excel 2007

As MS have dropped Application.Filesearch in XL2007 is there any
method available that can search for files in folders / sub-folders

TIA for any help

Raymond

 

[Guest]

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/office09072000.asp
Working with Files, Folders, and Drives: More VBA Tips and Tricks
by David Shank (Office talk)




http://support.microsoft.com/kb/185476/EN-US/
How To Search Directories to Find or List Files

http://support.microsoft.com/kb/185601/EN-US/
HOW TO: Recursively Search Directories by Using FileSystemObject

http://support.microsoft.com/kb/186118/EN-US/
How To Use FileSystemObject with Visual Basic