http://support.microsoft.com/default...b;en-us;185476
How To Search Directories to Find or List Files

this is a link to that article for the third method
http://support.microsoft.com/kb/185601/EN-US/
HOW TO: Recursively Search Directories by Using FileSystemObject

One for Information.
http://support.microsoft.com/default...b;en-us;189751
INFO: Limitations of the FileSystemObject



--
Regards,
Tom Ogilvy

"Frank" wrote in message
...
I am using the system Application.FileSearch but this can take a long time
to
find and write to a db table, I was wondering if there was an API function
that would find files quicker.
any help would be much appreciated.
Frank.