We have a lab instrument that generates CSV files that we would like to have merged into one Spreadsheet for analysis.

Each CSV is named sequentialy by the Instrument p1.csv, p2.csv.....p25.csv
Each CSV has two colums
Each CSV has from 100 to 50000 rows

Desired results would have the filename of the first csv in Cell A1 and the Data in columns A and B through however many rows starting in row 2.

The filename of the second csv would go in Cell C1 and the Data in columns C and D through however many rows starting in row 2.

Alternatively, each CSV could be a worksheet in a common workbook with the Sheetname set to the source filename.

Is there a simple way to accomplish this task?

It doesn't sound as hard as I have found it when I read it but VBA and Macros aren't really my forte'.

HELP Please,

Brian Main


[ This Message was edited by: Handyman4u59 on 2002-03-12 09:33 ]