Script VBA code to search Name list into Windows Folder

[Vandermeer]

Hello,

First of all, i'm a real novice about VBA code. I looked into alot of forum to find an answer for my question but i couldn't figure out how the code work.
My issue is very simple but coding this seems to be complicated (for me...).
I'm looking exactly a simple script that allows me to search all names files through a name list in Excel cells.

For example :

My excel has a column A :

A1 to A6, i have in the following cells : Burger, Banana, Strawberry, Apple, Orange, Ananas

In my Windows folder :

I have a following files.txt content named : Burger, Tacos, Plant, JoeBiden, Bed, PineApplePen, Banana, Strawberry, Apple, Orange, Ananas,

My result :

I want Excel to check cells A1 to A6 all the names and select/show me all files.txt that have these names only (Burger, Banana, Strawberry, Apple, Orange, Ananas).

Best Regards,
Vandermeer

 

[Rijnsent]

Hi Vandermeer,
welcome to the forum. First of all, this is a "help me writing this macro, this is where I am stuck" forum, not a "write this macro for me for free" forum. So given that you're a VBA novice, I assume you're enthusiastic about learning VBA. If you haven't found material yet, see e.g. Free VBA Training Course , Excel VBA Programming - a free course for complete beginners , a good Udemy course or e.g. WiseOwl.

Getting to your question, the first step is to transform that into pseudo-code:

• loop though all .txt files in a folder -> VBA code to loop through files in a folder (and sub folders) - Excel Off The Grid
• for every file in that folder, read it -> Excel VBA Programming - Opening Text and CSV files
• compare the contents with each of the cells cells A1:A6 (a loop: Excel VBA Programming - For Loops ) , note a match if all 6 cell values can be found
• close the file and do the next
• report the list of matching files, e.g. in column B

Hope that gets you started, don't hesitate to post your attempt here if you get stuck.
Cheers,
Koen

 

[Vandermeer]

Hi Rijnsent,

Thank you very much for your answer. I will take a look on it.

Best regards,
Vandermeer