VBA to search a string within multiple WKBs ?

[JumboCactuar]

Hi,
I have 100s of small files (roughly 50kb) with 2 columns of data all the same format.

How quick would it be to enter a string, then search that string in all files (column A)

Then return the filename + column B data

Wondering if it's more efficient to merge all workbooks first? As I'll be using this search repeatedly

Appreciate any help

 

[Fluff]

Re: VBA to search a string within multiple WKs ?

I'd merge the workbooks first.
Opening 100's of files will not be overly fast.

 

[JumboCactuar]

Thanks, I thought it would be

Problem is that the small files get added daily so I'll need to figure a way to add just the new files to the merged one.

 

[Fluff]

Once a file has been added, move it to a new location.
That way there won't be a problem.