PDA

View Full Version : Download Data From Internet using Excel macro



vilasc
07-11-2013, 04:27 AM
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

:banghead:

vilasc
07-11-2013, 04:28 AM
Website Name is nseindia.com/corporates/offerdocument/recent_issue.htm

vilasc
07-11-2013, 04:30 AM

joms
07-12-2013, 01:41 AM
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
07-12-2013, 02:42 AM
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
07-12-2013, 02:44 AM
Web query not working on this page....