Extract data from subfolders, concrete lists

[od33n]

Hi all

Please, tell me that this is possible

I have folder with plenty of subfolders, each of them contains .xlsm files
Each of this file have list named for example "location"
In this list, i have data, that i would like to have in one Excel file.

The more described situation in that "location" list is, that it is filtered data (1st row is the header). But i cannot assure, that all files have this header in same sentence or all of them contains all absolutely same names. Maximum of these columns is about 100, rows count can be from 10 to 20 000 in each file.

It would be brilliant if there will be some way of writing the data from all files into one sheet.
The result i d like to, is the header with those 100 columns filled with all data from subfoldered sheets.

I think example can be...


d:\temp\1\example1!location.xlsm

[TABLE="width: 500"]
<tbody>[TR]
[TD]a[/TD]
[TD]b[/TD]
[TD]c[/TD]
[TD]d[/TD]
[TD]e[/TD]
[/TR]
[TR]
[TD]a1[/TD]
[TD]a2[/TD]
[TD]a3[/TD]
[TD]a4[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

d:\temp\2\example2!location.xlsm
[TABLE="width: 500"]
<tbody>[TR]
[TD]a[/TD]
[TD]b[/TD]
[TD]c[/TD]
[TD]e[/TD]
[TD]f[/TD]
[/TR]
[TR]
[TD]b1[/TD]
[TD]b2[/TD]
[TD]b3[/TD]
[TD]b4[/TD]
[TD]b5[/TD]
[/TR]
</tbody>[/TABLE]

Result file

[TABLE="width: 500"]
<tbody>[TR]
[TD]a[/TD]
[TD]b[/TD]
[TD]c[/TD]
[TD]d[/TD]
[TD]e[/TD]
[TD]f[/TD]
[/TR]
[TR]
[TD]a1[/TD]
[TD]a2[/TD]
[TD]a3[/TD]
[TD]a4[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]b1[/TD]
[TD]b2[/TD]
[TD]b3[/TD]
[TD][/TD]
[TD]b4[/TD]
[TD]b5[/TD]
[/TR]
</tbody>[/TABLE]


Thanks for your responses...

 

[od33n]

I cannot modify it, but i have added one null to 20 000... real maximum of rows is about 2 000

 

[od33n]

closing this thread for now answers...