Excel VBA Automate to open CSV comma delimited file and copy to worksheet

Hi,

I have a CSV file that was exported from an SSRS report.
I have an excel with Button (form control) to open a CSV file. I'm trying to write a VBA macro to automate to open a CSV file comma delimited and copy the records to a worksheet. Any help is very much appreciated. thanks.

Below is a sample data.
The first row is the heading
Second row is the date and other parameters.
The Third row is the column heading
the Fourth row is the data that I would like to copy using vba excel

textbox1,txtFromDate,textbox3,textbox65,textbox67
11/5/2014 6:00 AM,11/6/2014 6:00 AM,User,TOP-FJ-PCM,ALL

lineid,textbox100,textbox101,textbox102,txtWrkCtr,textbox54,textbox72,textbox77
TOP_Line30,2676,2597,79,FJ_BAFF,363,361,2,FAJ1101-5-S,363,361,2