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
