Results 1 to 4 of 4
  1. #1
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: import from txt file (excel 2000)

    Hi Sal,

    Is this basically the same question as <post#=338794>post 338794</post#> in the VB/VBA forum? The code is not 100% the same, but it looks very similar.

  2. #2
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: import from txt file (excel 2000)

    Messaggio cancellato da sal21

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    import from txt file (excel 2000)

    Messaggio cancellato da sal21

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: import from txt file (excel 2000)

    I think the problem is (I don't have time to work thru it all tonite) is that you are ignoring most of the lines of text from the text file. I see 6 lines of code that read a line and then put it into "riga" and then read the next line into "riga" essentially throwing it away. Your text file does not look like it has the structure that only 1 of 7 lines is "parse-able". Based on the "good" output, there are times that you want to read and parse every line, this code will not.

    A suggestion to help understand what the code is doing:
    Step thru the code and watch what is in Riga at each step.

    I do not think you want to ignore any of the lines, but there will be some times you will do something IF the line meets some criteria.

    Steve

Posting Permissions

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