Hi,

Can you help me with the VBA code equivalent of this command line:

findstr /M /G:c:\search\pattern.txt e:\data\activity*.DAT
R:\results\found_file_names.txt

whe
findstr = finds strings
/M = print only the filename if a file contains a match
/G = get the search strings from the file c:\search\pattern.txt
e:\data\activity*.DAT = search all the activity*.DAT files lik
activity1.DAT, activity2.DAT, etc.
R:\results\found_file_names.txt = this is the file that will contai
the results of the search (the results will be just the file names tha
contain the search string)

With this working, I need to load the results into a spreadsheet.

Appreciate it

--
Message posted from http://www.ExcelForum.com