Results 1 to 8 of 8

Import user selected columns from a text file

Threaded View

aarho Import user selected columns... 12-04-2012, 02:40 PM
rylo Re: Import user selected... 12-04-2012, 11:58 PM
aarho Re: Import user selected... 12-05-2012, 01:19 PM
rylo Re: Import user selected... 12-05-2012, 06:49 PM
rylo Re: Import user selected... 12-05-2012, 08:01 PM
aarho Re: Import user selected... 12-06-2012, 06:57 PM
rylo Re: Import user selected... 12-06-2012, 08:28 PM
aarho Re: Import user selected... 12-11-2012, 08:28 PM
  1. #1
    Registered User
    Join Date
    09-20-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    13

    Import user selected columns from a text file

    Hi,

    I'm trying to write a macro that imports a tab delimited text file. The issue I'm having is that the files tend to be pretty big, so I want it to only import the reference columns (from 1 to 6) and channel columns (from 1 to 16) selected by the user.

    I've managed to write an inelegant if statement that works for the channel select option but adding in the reference option would give almost 100 different scenarios, so I figured there has to be a better way to do this

    I've attached a text file showing roughly how the data is presented in the text file (there are a lot of useless columns but this is the way it's given to me for now) and a file with the macro that I've been using for one option.

    Hope someone can help.

    Cheers.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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