VBA equivalent of findstr

[lothario]

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

where:
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

 

[Guest]

In the debug window type instr( and read the popup

----- lothario > wrote: -----

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

where:
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 like
activity1.DAT, activity2.DAT, etc.

R:\results\found_file_names.txt = this is the file that will contain

the results of the search (the results will be just the file names that
contain the search string)

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

Appreciate it.

 

[Tom Ogilvy]

see the help on the filesearch object for a VBA method. There may be a
closer equivalent in one of the scripting libraries.