VB Code to dynamically read csv files and create charts within Excel.

Hi

I am looking at creating an excel sheet which has about 15 worksheets . Each worksheet has its own csv file to be read and loaded . Once the data is loaded then I would like to add charts for each worksheet.

My problem is 2 fold :

1. How to code the above
2. The csv data that is required for each sheet may vary in number of rows. The number of Columns will be fixed to either 4 or 5 columns.

Please help as this is my first time I am attempting this excercise. I need to complete this same ASAP . I have Excel 2007 with me.

Another problem I am facing is when I plot the XY Scatter diagram the x-axis which is in my will always be a date field shows the points for all missing data also.

e.g. : My data is :

10-sep-12 1 2 3
15-Sep-12 6 8 9
16-Sep-12 8 10 10

The x-Axis shows

min Point as 09-Sept-12
Max point as 17-Sept-12

As well as all the other missing points between 10-15 Sept.

This data will change everyday.

Thanks & Regards