+ Reply to Thread
Results 1 to 1 of 1

Reading different lines of data from a textfile into Excel

  1. #1
    Registered User
    Join Date
    11-21-2012
    Location
    Pretoria, South Africa
    MS-Off Ver
    Excel 2007, 2010
    Posts
    5

    Reading different lines of data from a textfile into Excel

    I have extracted data from a text file with the help of a VB library file which was provided with the text file. The code did what is expected to do but have came across few problems, please bear with me I'm still a newbie to this:

    1) Reading from line 20-877(used Notepad++), the aim was to add data from column A and column B, this works but from line 607 is on longer the case. Is there a way
    to go around this?
    2) When the code encounter an "empty space or # or & or *" it read them as values.
    Is there a way to work around this so that the code can simply ignore them and pick the next value it see on the same line?
    Any ideas on how to extract data from lines 885 and 907, respectively?

    I have attached the data, code used and .bas as a pdf files used.
    Thanks in advanced
    Attached Files Attached Files

+ 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