Hi all, hope I've posted this in the correct forum!

I have a folder full of csv files that I want to extract data from. It's foreign exchange data and is located in C:\Data\FOREX on my computer, each file name is for a currency pair(EURUSD.csv,AUDUSD.csv, etc). Data within the files is organised like this:

08/12/2011,1.0341,1.0361,1.0247,1.0353

What I want to be able to do is to extract data for a particular day from each file and have 1 excel file that contains the data for each day for all of the files in the folder, as well as the filename it came from, so that the end result looks like:

AUDUSD,08/12/2011,1.0341,1.0361,1.0247,1.0353
EURUSD,08/12/2011,1.4236,1.4291,1.4150,1.4246

Presently I open up a new worksheet, type in the currency pair in cell A1, then open up the corresponding file and copy and paste the data in cells A2 to A6, then do this for all 84 files in the folder. Obviously this isn't an enjoyable task and is something I'm looking at trying to automate.

Any help or tips on how to do this would be greatly appreciated.

Cheers