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...