Loop through a folder in the computer

[red1234]

Hi,

I need to do a loop that goes through a folder on the computer. What I'm aiming to do was gather all of the information from a folder of excel files (where files have names I didn’t know & therefore couldn't specify beforehand), of varying names & varying quantity, but with the same defined names & so on within the spreadsheet(for example all the files have the same name for the sheet I'm interested in extracting the data from, but the file names can change or new files can be added to the folder but since is the same template for all of them the cell location and sheet's name will not change)

Basically the loop should go into each file and look for a specific sheet let's say "abc" then loop through column A with the header set1 and count how many cells containing the word "blue" are, how many with the word "red" and so on (Let's say there are only 3 colors-red, blue, yellow) Then move to column B "set2" and do the same operation . As a result I would like to display in a separate worksheet, from where I run the code, the results in a table with 2 headers set1 and set 2 and the specific result for each color in each set in a sheet called "results". Bothe the header for my table and the sheet name is already predefined, so basically just the numbers have to be added to the tables in the specific cells.

I would really appreciate some help.

Thanks,
Red

[Bernie Deitrick]

Put this into your workbook, and save it in the same folder as your other files.

This assumes your table is set up with 7 columns of value - the first for the file name and six for data: red, blue, yellow from column A, then from column B.

Please Login or Register  to view this content.