sibling folders paths in VBA

seba64

New Member
Joined
Apr 24, 2016
Messages
31
HI.

I have an app. that read many files. now requestme the files must be clasificated in different folders.
Now i read the files from application.path & "\data\*.xlsx", but now the folders with files are out of application.path.

now!:
..................................................
. [Folder]
... !-aplication.exe
... !-[Data]
....... !- data1.xlsx
....... !- data2.xlsx
....... !- data2.xlsx
....... !- data2.xlsx
....................................

but the request now:
.............................................................................................................
.[aplication]......... [Folder1] ....... [Folder2] ....... [Folder3] ...... [Folder4]
. !-aplication.exe .... !-data1.xlsx .... !-data2.xlsx ... !-data3.xlsx .. !-data4.xlsx
............................................................................................................

I hope can understand all that
and i hope you can help me please


sorry for my bad english. ;)
 
Last edited:

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

seba64

New Member
Joined
Apr 24, 2016
Messages
31
24 views and no threads.
Just want to know how can get the paths of all folders at the same level.
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,108,789
Messages
5,524,885
Members
409,609
Latest member
Channingz

This Week's Hot Topics

Top