find a company name in 7 different .csv files

[vbnew24]

Hi all,

I have just started to learn VBA, but I am facing a tough challenge now. It would be really helpful, if someone could help me with this.

I have a .xls file in which I have stored 1000 company names. The program has to take one company name at a time from the .xls file and search in 7 different .csv files. If that company name is present in any of the file then it should return yes to the column next to the company name in the .xls file, if it is not present a "no". Is this easy to do? Being a beginner I feel it is difficult. Each of the .csv file where the company name has to be searched has 60,000 rows and almost 30 columns. But only column N is required for us, as the company names will be present only in that column. Previously it was one big .csv file which had 380,000 rows. I took a code online to split them into 7 different files, as it was very slow when i operated with one big file. Earlier sometimes I even had trouble opening the file because of it size.

Let me know if anyone could help.

Thanks.

[westconn1]

Is this easy to do?

yes

put no in next column, open each csv file (as text file) in turn, read file into variable, use instr to find company name, if found skip rest of files, put yes in next column

without knowing file name sequence, it is not really possible to give code example