I have a directory "c:\ASCII\" contains thousands of csv files (source data) with 6 columns, where column A are dates in ascending order. The file name structure of the csv files is "(000#) xxxx", which means the file names are 4 digits numbers with brackets (never repeat), space and name.

An existing workbook have 2 reference cell. A1 is a date . A2 is a number without zeros in front, which means "1" instead of "0001".

What I need to do is to reference A2 to open the corresponding csv file. Then, reference the date of A1 and copy all the rows within a year range from the csv file to existing workbook. That means if A1 is 12/31/2010, I need to copy rows with date from 1/1/2010 to 12/31/2010.

Any help is much appreciated.