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.