If you look at the edit to my solution to your previous post importing from excel to listbox
] you will notice that I have already explained what the problem is
To reiterate, the for loop
For i = 0 To AscW(ListBox1.Items.Count.ToString()(i = i + 1)) - 1
is only looking at items that are already
in the ListBox
Go back to your previous post and look at the WHILE loop I provided.