05-28-2009, 04:57 PM
Hi
I exported all the links of that table to a excel sheet later i want to loop on that column in excel and very first occurence link which starts with LAUSD i want to take as input and click on that click.
I did something like this:
But it does not show any error message.What might be wrong in this?I think it takes it has a string in val variable.
Any help regarding this would be appreciated in advance.
Tahnks..
I exported all the links of that table to a excel sheet later i want to loop on that column in excel and very first occurence link which starts with LAUSD i want to take as input and click on that click.
I did something like this:
Code:
Set oDesc=Description.Create()
oDesc("html tag").Value="A"
Set rc = Obj.WebTable("name:=Track").ChildObjects(oDesc)
num = rc.Count()
For i=3 to num-1
tag = rc(i).GetROProperty("innertext")
'msgbox tag
linkval=tag
osheet.cells(i,11)=linkval
Rowcount =osheet.usedrange.rows.count
For y=3 to Rowcount
val=osheet.cells(y,11).Value
If (val="LAUSD") Then
Obj.link("text:="&val).click
End If
Next
Next
But it does not show any error message.What might be wrong in this?I think it takes it has a string in val variable.
Any help regarding this would be appreciated in advance.
Tahnks..