William,
It has a "TextStream Object" with which you can read or write text files.
I don't know of any way for it to read an Excel file.
Regards,
Jim Cone
San Francisco, USA
"William Benson" wrote in message
...
Jim, can filesystemobject search in the file for text, I thought Ken was
needing to do that ...?
"Jim Cone" wrote in message
...
Ken,
I've seen comments in the programming group to the
effect that FileSearch is not always reliable.
See Myrna Larson's comments here as one example...
http://makeashorterlink.com/?C3145206B
The FileSystemObject code, part of the Windows Script Host
included with the Windows operating system (after Windows 95)
seems to be rock solid dependable and can be freely intermixed
with VBA code. For what it's worth, the following is code that
searches for files in the top folder and all sub-folders.
The results are listed on the active sheet.
-snip-