Search WebTable?

[surya_7mar]

Code:

row = Browser("").Page("").WebTable("").GetRowWithCellText("GD APRS Nine,Internet,Jun 18 2010 4:57PM", 2, 7) Set View = Browser("").Page("").WebTable("").ChildItem(3, 7, "Link", 0) View.Click

Try this?

[sasmitakumari]

Hi,

Can u provide snap shot of your webtable(part of it- with all columns in it with few rows"), which will help me to provide you sample code how to click on the link using DP?

Sasmita

[Brian T.]

Thanks,

For all the help!

I was able to use the below code to search a web table for a specific Name(Andrew APRS Fox) and a specific Access Type(Internet)for the current date and once found click on the link in the 7th column for that specific request. Here is the code in case someone else has a simular issue.

Again Thanks for all the Help!

Code:

Dim objTable, intRow Today = MonthName(Month(Now),True)&" "&Day(Now)&" "&Year(Now) Set objTable = Browser("").Page("").WebTable("") Rcount = 1 do until Rcount = objTable.RowCount +1 If objTable.GetCellData(Rcount, 1) = "Andrew APRS Fox" Then If objTable.GetCellData(Rcount, 3) = "Internet" Then If Mid(objTable.GetCellData(Rcount, 5),11,1) = " " Then covdate = Left(Today,10) Else covdate = Left(Today, 11) End If If covdate = Today Then If objTable.GetCellData(Rcount, 6) = "PENDING APPROVAL " Then Exit do End If End If End If End If Rcount = Rcount + 1 loop If Rcount = objTable.RowCount +1Then msgbox "No Matching Records Found" End If Set View = Browser("").Page("").WebTable("").ChildItem(Rcount, 7, "Link", 0) View.Click

Thanks,
Brian

[Arun Prakash]

Hi Brian,

Code:

row = Browser("").Page("").WebTable("").GetRowWithCellText("GD APRS Nine,Internet,Jun 18 2010 4:57PM") Set View = Browser("").Page("").WebTable("").ChildItem(row,7,"Link", 0) View.Click

I hope the above code will solve your problem