troubleshooting Question

VB Script to search multiple txt files for results from an excel list

Avatar of jamiepryer
jamiepryerFlag for United Kingdom of Great Britain and Northern Ireland asked on
VB Script
5 Comments1 Solution1022 ViewsLast Modified:
I have a list of 24 different txt files (size from 4kb - 366kb)
I also have an excel file which is a list of 6628 lines, from cells A1:A6628

I want to search each of the excel files to see if value in the excel file is listed in them.
If so, i want to display the txtfile name next to it, in cell Bx

The other thing, which should hopefully make the script run faster, is that if a result is found in 1 txt document, i dont need it to seach that result again in any of the future txt documents, so hopefully as the script moves on, the list to seach on is smaller and so runs faster?

Can someone point me in the right direction, as i have no idea.

If its easier, i dont mind running this script on each of the text files 1 by 1, to make the code less complex, just using a simple sFileName = "C:\Data\datadump\test.txt"  or something.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros