How do you do a file search in XL2007
 

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

How do you do a file search in XL2007
 

http://msdn.microsoft.com/library/de...ce09072000.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

--
Regards,
Tom Ogilvy


" wrote:

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