+ Reply to Thread
Results 1 to 5 of 5

vba only import columns from csv with specific text in row A

  1. #1
    Registered User
    Join Date
    12-08-2010
    Location
    Brussel
    MS-Off Ver
    Excel 2007
    Posts
    12

    vba only import columns from csv with specific text in row A

    Hope you can help me how to code the following
    How to import a csv file where it should only import only columns with a specific text (header) as it can sometimes differs from columns

    Eg in cell

    A1 Client Name
    B1 Contracted
    C1 Address
    D1 Sales
    etc
    Lets say I want only the columns Client Name, Sales. Etc imported to save speed and space

    Can anyone help me pls?

    Thanks
    Last edited by CuvelieY; 01-17-2011 at 08:02 AM.

  2. #2
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: vba only import columns from csv with specific text in row A

    hi, it would be helpful to see the csv file

  3. #3
    Registered User
    Join Date
    12-08-2010
    Location
    Brussel
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: vba only import columns from csv with specific text in row A

    shure

    as an example, but the file number of columns are much larger

    Thanks
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    12-08-2010
    Location
    Brussel
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: vba only import columns from csv with specific text in row A

    The issue is that the csv file doesn't have the same seup all the time, but the cells in row 1 does,
    so it should only import the pre-specified ones

  5. #5
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: vba only import columns from csv with specific text in row A

    how the column headers are supposed to be prespecified?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1