VB Forum / General / November 2008

I'm using vb.net and I'm sorting several listview rows by the 1st column date
using a comparator sort routine. I'm sending this sorted info to a word
document. The listview sort results are correct but when I use a loop to
generate the item index(as below), the original unsorted order is sent to the
word document.

For zRow As Integer = 0 To LV1.Items.Count - 1
       
       With oTable
           ' Insert the data into the specific cell.
           .Cell(zRow, 1).Range.InsertAfter(LV1.Items(zRow).Text)
           .Cell(zRow, 2).Range.InsertAfter(LV1.Items(zRow).SubItems(1).Text)

           .Cell(zRow, 3).Range.InsertAfter(LV1.Items(zRow).SubItems(2).Text)

           .Cell(zRow, 4).Range.InsertAfter(LV1.Items(zRow).SubItems(3).Text)

       End With
         
Next zRow

But it gets better....
If I move the above code to a button_click procedure, it sends the correct
sorted order to the word document???

As you can tell I'm a VB6 user and a novice at that.

Thanks for any help,
Bob