none
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

    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


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

Answers

All replies