[Help] CSV auto import by Excel VBA

[robert8628]

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

[westconn1]

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?

[robert8628]

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