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

  • Question

  • Hi,

    I have a requirements to read CSV file that was exported from an SSRS report and stored in C:\SSRS Report\Sample.CSV.
    I have an excel workbook 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.

    Need to copy/dump the records started from third row up to the last row with empty data.

    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

    11/5/2014 6:00 AM,11/6/2014 6:00 AM,User,TOP-FJ-PCM,ALL

    • Edited by Lenoj Friday, November 7, 2014 8:28 AM
    Friday, November 7, 2014 8:27 AM


All replies