[Help] CSV auto import by Excel VBA

Hi all,

I have multiple excels file, multiple folders and multiple CSV files.

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

How do I using VBA 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 sheet by the folder Date?

I would do the VBA automatically, as I open test1.xls then Run VBA. It asks selected the folders(i.e. 2013-05-01,2013-05-02, 2013-05-03 & 2013-05-04).
Auto import all CSV which same name as "test1.csv" into the test1.xls.

Thanks

you want all test1 in same sheet or each test1 in separate sheet?
how to name sheets if the latter as they would all be named test1?

Hi,

Thanks your reply.

It's a test report.

Each sheet name should be a date of the folder.

By using another excel,
1 select the test_result folder,
2 select the test_result XLS that need to import
3 select the date folder contain the csv files
4 auto import all the "same test name" csv into "same test name" excel.

thanks