Loop through folders and execute code if folder name matches specified names

[hopeful_positive]

Hello all,

I am new to VBA coding. I had taken a programming course almost 6 years ago and never touched it since but I would like to start learning slowly to automate a lot of my excel stuff.


I am looking for help to code the following the scenario:

I have 10 folders in a particular location on the drive. Out of the 10, there 7 which are named Item 1, Item 2, Item 3, Item 4, Item 5, Item 6 and Item 7. The remaining three are not to be worried about.

I am hoping to code in VBA such that the code would loop through all the folders and if the folder name matches - Item 1, Item 2, Item 3, Item 4, Item 5, Item 6 and Item 7 - execute code A for folders Item 1, Item 2, Item 3 and then execute code B for Item 4, Item 5, Item 6 and Item 7.

Requesting your kindest help.

Thank you !

 

[Fazza]

which bit do you want help with?

you'll find most of what you need via google. i just googled with input copied straight from your question

googling for "VBA such that the code would loop through all the folders" finds, amongst others,
https://exceloffthegrid.com/vba-code...r-sub-folders/
https://www.quora.com/How-do-I-loop-...soft-excel-vba

After that you might google for info on a 'select case' statement. Or even a simple IF statement, just to get started.
I googled for "VBA do different things based on value" and found
https://powerspreadsheets.com/excel-vba-tutorial-essential-terms/

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...yesterdays-month-post5052738.html#post5052738

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).