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