|
Can I help you?
browser("").Page("").WebList("").Select("")
totalRow = Browser("").Page("").WebTable("").RowCount
For i = 1 to totalRow-1
itext1 = Browser("").Page("").WebTable("").GetCellData(i,2)
itext2 = Browser("").Page("").WebTable("").GetCellData(i+1,2)
For j = 1 to 18
firChar1 = Mid(itext1,j,1)
firChar2 = Mid(itext2,j,1)
If firChar1 = firChar2 Then
'msgbox "should compare the next character."
Else
itext1Asc = Asc(firChar1)
itext2Asc = Asc(firChar2)
If itext1Asc < itext2Asc Then
'msgbox "should jump out this loop, compare next two lines"
Exit For
Else
msgbox "sort ascending failed, taken places on " & i & " and " & i+1 & " lines"
ExitAction(-1)
End If
End If
Next
Next
msgbox "sort ascending successfully!" |
|