Combining Multiple CSV Files using vba code

  • Thread starter Thread starter davebop
  • Start date Start date
D

davebop

I have several csv files all with the same columns of data.

The filenames are all in the same format (usage_01_monday.csv
usage_01_tuesday.csv, etc.)

I would like to combine the csv files into one masterfile, by th
number in the filename. Therefore something like usage_01_*.csv need
to be used i think.

Can anyone help
 
I'd shell to DOS and do it with an old DOS command.

Travers to that folder that holds these files:

copy usage_*.csv all.csv

Then back to excel and import all.csv
 
Back
Top