How to click on link/path given in search result via vba

[vbambre]

Hi,

I am new to internet explorer automation, and currently working on one macro.90
Macro need to do go to the specific url then search with code given in sheet and click on search button, after search in search result, i need click on 3rd column data "subject"(highlighted in below image) which will open one more small window open which contain data in table format. I want this data in excel front of code

Query: I am able to write code till click in search button, but i am not able to write code to click on above highlighted subjects, I need help here. below is my code.
Thanks in advance

Sub feeder() ' ' feeder Macro ' Dim IE As Object Dim doc As HTMLDocument Dim vb As Object Set IE = CreateObject("InternetExplorer.Application") IE.Visible = True IE.navigate "https://www1.nseindia.com/corporates/corpInfo/equities/Announcements.html" Do While IE.Busy Or IE.readyState <> 4 Application.Wait DateAdd("s", 1, Now) Loop Set doc = IE.document For i = 13 To 50 doc.getElementById("company_name").Value = ThisWorkbook.Sheets("Data").Range("A" & i).Value doc.getElementById("ext-gen18").Click 'need code to select subjects in seach results and get the table data in excel Next End Sub

 

[vbambre]

Please someone help me

 

[vbambre]

below is the code, please help me how can i select this link which will open new table window.
<div class="x-grid3-cell-inner x-grid3-col-3" unselectable="on" id="ext-gen141"><span style="color:blue; cursorointer; hover:underline" id="ext-gen142">Change in Director(s)</span></div>

 

[vbambre]

correct code

<div class="x-grid3-cell-inner x-grid3-col-3" unselectable="on" id="ext-gen141"><span style="color:blue; cursor:pointer; hover:underline" id="ext-gen142">Change in Director(s)</span></div>