I've been looking at Leith Ross's solution to a similar issue posted
yesterday which goes some way to answering my problem. However his solution
throws up formatting issues for me as two of the fields I wish to import are
date and time.

Look forward to any ideas,

Ian.


"Ian" wrote:

I have a series of around 500 .csv files, stored in one defined directory,
which I would like to merge into one Excel spreadsheet. All the .csv files
have data in the same format but very in the number of rows of data they
contain, varying between one and ten rows of data.

Is possible to write a piece of code that will open each .csv file, in the
directory, in turn, determine the number of rows present, copy that number of
rows of data and then paste|append those rows into a master Excel worksheet?

Thanks for any pointers,
Ian.