Web scraping for stock data macro

Hello

I am trying to make a web scraping macro in order to get stock information from a website based on the stock's registration number (ISIN number)

Here is what I have so far:

Please Login or Register  to view this content.

The ISIN number is being input into the search box on top of the page. After inserting the ISIN number an autocomplete table is generated, which contains the necessary query string that is needed in order to navigate to the stock's main page.
What I need is to get the "innerText" from the "link" attribute of the second <td> tag, however upon running the macro it returns that value as "null". The HTML code generated from the website is in the attached word file.
Would be great if someone could help out.

Thx in advance!

Hi !

From the table object, use its Rows / Cells collections …

Isn't the For each loop already doing so?