Download Data From Internet using Excel macro

[vilasc]

Want to Download All Company name from dropdown of below URL
URL : "http://nseindia.com/corporates/offerdocument/recent_issue.htm"

Trying below code but its not working

Sub COMPANYNAME()
Dim ie As Object
Dim s As Object
Dim sm As String
Set ie = CreateObject("internetexplorer.application")
With ie
.Navigate "http://nseindia.com/corporates/offerdocument/recent_issue.htm"
.Visible = True
End With

Set s = ie.Document.getElementById("ext-gen35")


sm = s.selectedindex = 1



End Sub

 

[vilasc]

Website code like

""""<div class="search-item x-combo-selected"> h3><span>ACC Limited</span></h3 </div></div>"""



want to download this data in excel using vba macro please help...........................