Hy, I'm new in VBA,
I need some example of code VBA for get list of subfolders with specified name to put in excel table. Name of my folder is like:
AUD_C1234_02_PRODUCTS

I want to get names like this (each folder names in new row) in to table that I have 4 columns, so separator for new columns is underscore _
Final result must be:
ColumnA ColumnB ColumnC ColumnD
AUD C1234 02 PRODUCTS
Does anybody know , or can help me please

Thanks A lot