Hi all
I have folder with a lot files like: xxxxxx-yyyyyyyy-zzzzzzzz-wwwww-aa-b-cc with extension: .xlsx .xlx .rpt .doc .docx
Please help me with macro VBA to do that:
1. Brown to folder and get all files full name include extension: .xlsx .xlx .rpt to sheets("data") begin from range ("A2")
2. Split all file name from column(A) to column B,C,D,E,F,G,H,I for each dash "-"
The result like this, I examble 03 row but realyty rows defend on the file name in folder from 200 to 500 files each month:
<tbody>
</tbody>
Thanks in advance.
I have folder with a lot files like: xxxxxx-yyyyyyyy-zzzzzzzz-wwwww-aa-b-cc with extension: .xlsx .xlx .rpt .doc .docx
Please help me with macro VBA to do that:
1. Brown to folder and get all files full name include extension: .xlsx .xlx .rpt to sheets("data") begin from range ("A2")
2. Split all file name from column(A) to column B,C,D,E,F,G,H,I for each dash "-"
The result like this, I examble 03 row but realyty rows defend on the file name in folder from 200 to 500 files each month:
A | B | C | D | E | F | G | H | I | |
1 | xxxxx-yyyyyyyy-zzzzzzzz-wwwww-aa-b-cc.xlsx | xxxxxx | yyyyyyyy | zzzzzzzz | wwwwww | aa | b | cc | xlsx |
2 | xxxxxx-yyyyyyyy-zzzzzzzz-wwwww-aa-b-cc.xls | xxxxxx | yyyyyyyy | zzzzzzzz | wwwwww | aa | b | cc | xls |
3 | xxxxxx-yyyyyyyy-zzzzzzzz-wwwww-aa-b-cc.rpt | xxxxxx | yyyyyyyy | zzzzzzzz | wwwwww | aa | b | cc | rpt |
<tbody>
</tbody>
Thanks in advance.