Search Multiple Excel Files and insert into Matrix with results

[robertbuff]

Hi, This is my first post here. I apologize in advance for any posting errors.

I have a folder containing 10K+ of xls files that I need to analyze then input into a single worksheet.

Attached is an example of expected inputs and outputs.
aaa.bbb.Ccc.DdD.xls eee.fff.Ggg.HhH.xls Output.xlsx

The input file has three Columns (Type, Field Name, Depth, Default Value). What I need to do is create a matrix of the Types column specifically the “Class…” values. The cell next to the “Class..” cell will always have the value "<SUPER-CLASS>". The tricky issue is that I don’t know all of the “Class…” names. I expect the number of “Class…” columns to be around the 10K+ range, similar to the number of files.

I believe this could be accomplished with VB code, but I have no experience with VB.
Thanks
Rob

[robertbuff]

Below is my VBA code to almost solve my problem.

This was my first VBA code and was wondering if anyone has recommendations on what i could have done better.

Also I am still trying to figure out the following issues. Any help would be greatly appreciated.
1. Would like to sort the columns on the merged worksheet and all associated data
2. how do I re-size cells to fit contents on the merged worksheet?
3. Is there a way to setup and configure Auto Filter on the merged worksheet?

Please Login or Register  to view this content.