VB macro for extracting text from Excel files

[doropeter]

Hi!
I've been trying to come up with a macro to search for specified information in a bunch of excel files, then if the search text is found, then extract the entire row to an other workbook.
To explain it a little bit more detailed: I have 1500 excel files, (each having only one worksheet in it), each file has the exact same structure.(25 columns, and a varrying number of rows, 10 to 500). Files contains sales information. Each customer has his purches information in a separate file. In the files each sale event is recorded in separe row. In column 21 the name of the product is recorded.
My goal is to find all sales of a certain product. For example I have to find all sales of bandaids. So in each of the 1500 files I have to search for the word "bandaid". There can be customers who have not bought any, and there are customers who had it 30 different times. So I have to find these cells, then I have to copy the entire row (all the information about that sale event) to a separe workbook.
Therefore finally I should have one worksheet that has all the sale event of bandaid.

 

[Legacy 98055]

Best bet would be to create a simple table from your workbooks and then query the database. Email an example workbook or post it here. mrexce@fuse.net

Tom

 

[doropeter]

Hi Tom,
Putting all the files in one workbook won't work, as the number of lines are far beyond the limits of an excel workbook.
But finally I could solve the problem, and I created the macro that does the job.
If you are interested in it, I can e-mail it to you.
Peter

 

[Legacy 98055]

I meant an mdb. No need to mail it.