Download Data From Internet using Excel macro

[vilasc]

Want to Download All Company name from dropdown of below URL


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
.Visible = True
End With

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


sm = s.selectedindex = 1



End Sub

[vilasc]

Website Name is nseindia.com/corporates/offerdocument/recent_issue.htm

[vilasc]

[joms]

i don't think excel vba is a good way to accomplish your needs..

you should try javascript, asp or php it would be much simpler and feasible.

[snb]

i don't think excel vba is a good way to accomplish your needs..

you should try javascript, asp or php it would be much simpler and feasible.

You are mistaken. See e.g. webquery.

[vilasc]

Web query not working on this page....