Results 1 to 2 of 2

Thread: help with a code snippet for files

  1. #1

    Thread Starter
    New Member
    Join Date
    Mar 2000
    Posts
    10
    I was wondering how to increase "lstMRP" to the next list item so it can be compared to the file "C:\item.csv" and the records in there. I can't figure out how to increase "lstMRP" trying various ways like increasing the listindex number, but I may have done that wrong because I displayed the "lstMRP" and "strMRP" in a msgbox and the "lstMRP" was the same number everytime.

    Open "C:\item.csv" For Input As #1
    Do Until EOF(1)
    Input #1, strMRP, strA, strB, strC, strNotch
    If lstMRP = strMRP Then
    Open "C:\itemnew.csv" For Append As #2
    Write #2, strMRP, strA, strB, strC, strNotch
    Close #2
    Else
    msgbox("item was skipped")
    End If
    Loop
    Close #1

    any help please


  2. #2

    Thread Starter
    New Member
    Join Date
    Mar 2000
    Posts
    10
    Never Mind I got It

Posting Permissions

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



Click Here to Expand Forum to Full Width