how to create csv auto importer using excel vba

[Robert8628]

Hi all,

I have more than 50 folders and test.csv files.

I consider the VBA can only need to select the "CSV folders", than the excel can auto import all the relative CSV in the excel file.

e.g.
Folder name: 2013-05-01
Content:
- test1.csv
- test2.csv
- test3.csv

Folder name: 2013-05-02
Content:
- test1.csv
- test2.csv
- test3.csv

Folder name: 2013-05-03
Content:
- test1.csv
- test2.csv
- test3.csv

Folder name: 2013-05-04
Content:
- test1.csv
- test2.csv
- test3.csv

Folder name: Test_Result
Content:
- test1.xls
- test2.xls
- test3.xls

Condition: To import the above CSVs into the Test_Result folder xls file(by the same name as the CSV and append after last sheet of original xls) and named the worksheet name by the folder Date.