Is there any easy way to validate multiple hyperlinks in a page

[iamsekhar]

Scenario:
I have explained scenrio in attached screen shot, plz refer

1. By clicking on every link the xls file will open then i should validate row count in xls file to the hyperlink number. (I have done this scenario)
2. My question is: In my page around 2000 hyperlinks are there, i have to click each and every hyperlink or is there any other way?

Code:

Window("Lilly Science Grid").Page("Page_3").Link("25").Click // clicked on hyperlink
'Getting all hyperlinks in a page
Set Links = Window("Lilly Science Grid").Page("Page").Object.getElementsByTagName("a")
Msgbox "Total links:" &Links.Length

I will appreciate your help
Kindly suggest approach...

[KavitaPriyaCR]

Hi
your question is not clear...Why you are clicking on the link each and every time?
What is your doubt?

[A.Saini]

Hi Sekhar,

Please let me know whether I am getting your question correctly or not.

You have a excel sheet in which 2nd & 3rd columns contains hyperlinks (the value of hyperlink is a number) for each row.

Now you have to click over each & every hyperlink. If you click over a link it opens a new excel sheet. You have to count the number of rows of new sheet.

Now I have two questions.
1. Is there any relation between the ‘hyperlink value’ & the ‘rows count of the sheet’ which comes after clicking over the hyperlink?
2. Is the row count & hyperlink value is changing very frequently?