VBA: Get all CSV file data from a folder in one excel sheet named "atlas".
1. I have thousands of CSV files in a folder (only two-column data).
2. With VBA can I get the data in one excel sheet named "atlas" from the second row.
3. In the result sheet named "atlas" there are file names (In Column A/rows), and their headings are as per data appears vertically in the first column of CSV files.
Example CSV file:
Example output sheet "atlas"
1. I have thousands of CSV files in a folder (only two-column data).
2. With VBA can I get the data in one excel sheet named "atlas" from the second row.
3. In the result sheet named "atlas" there are file names (In Column A/rows), and their headings are as per data appears vertically in the first column of CSV files.
Example CSV file:
| BookTXTa with code2.xlsm | ||||
|---|---|---|---|---|
| A | B | |||
| 1 | 123#A | |||
| 2 | London | + | ||
| 3 | ||||
| 4 | ||||
| 5 | Apple | positive | ||
Sheet5 | ||||
Example output sheet "atlas"
| BookTXTa with code2.xlsm | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | London | none1* | Apple | ||||||
| 2 | filename1 | + | positive | ||||||
| 3 | |||||||||
| 4 | |||||||||
| 5 | |||||||||
| 6 | filename2 | … | … | ||||||
| 7 | filename3 | … | … | ||||||
atlas | |||||||||
