Automating CSV imports to the same spreadsheet.

Hi there,

I have a series of CSV files which I'd like to collate into one excel worksheet, but I'm struggling to find a pre-written solution. The CSV files are all 2 columns each, with the same number of rows. The first column of each file is identical.

I would like to create a worksheet which has the following format:

- first row contains file name which data came from
- first column contains the first column of first file
- second column contains the second column of first file
- third column contains the second column of second file, etc etc

I've pulled the following code from the web, but I'm not 100% where to start with editing it as I've not used VBA before, so any help would be much appreciated!

cheers,

Jamie

Please Login or Register  to view this content.

Maybe like so:

Please Login or Register  to view this content.