Combining Multiple CSV Files using vba code

[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

 

[Dave Peterson]

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