Well, after so many tries, finally I did something to start to fix my problem:
I used a variable to store the label value on web site, then in while I search for the row that has the same value than label.
Now I need one more thing, The label that I have to compare has a value that changes everytime (i.e. "TAN No. xxx", where xxx is the varying number)
I don't know how to do that, I was thinking something about checkpoint that field. Or maybe a way to read that field on the site and assign the value to a variable and compare.
Quote:set ex= CreateObject("Excel.Application")
Set a=ex.Workbooks.open("c:\Book3.xls")
Set b=a.worksheets("Sheet1")
dim fieldcheck, branch1, label
label = "Branch(three-digit)"
i=1
While (label <> fieldcheck)
fieldcheck=b.Cells(i, "A").value
If label = fieldcheck Then
branch1=b.Cells(i, "B").value
End If
i = i+1
Wend
Browser("...").Page("...").WebEdit("branch").Set branch1
I used a variable to store the label value on web site, then in while I search for the row that has the same value than label.
Now I need one more thing, The label that I have to compare has a value that changes everytime (i.e. "TAN No. xxx", where xxx is the varying number)
I don't know how to do that, I was thinking something about checkpoint that field. Or maybe a way to read that field on the site and assign the value to a variable and compare.
