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

Please Login or Register  to view this content.

Try this VBA

Please Login or Register  to view this content.