Select from Drop down list in Internet Page

Abdullahorhn

New Member
Joined
Jan 9, 2019
Messages
5
ı am new vba and here. I am working on stocks and ı need your helps. so firstly as you can see on tittle, ı want to choose automaticly in down list what i write on my excel. So ı need amortization information from this web site website in "MALİ TABLOLAR"page amortization in turkish is amortisman and it is the end of the page.The cods that ı write working halfway ı can go just "mali tablolar" page and ı cant choose date from down list.
in epitome, i will write to a2 cell and this macro will take amortization info with correct date. Sorry for bad english. I hope you understand me thanks for help
PHP:
Sub Düğme2_Tıkla()sirketismi = Range("A2")
Dim ie As New InternetExplorerie.Visible = Trueie.navigate ("https://www.isyatirim.com.tr/tr-tr/analiz/hisse/Sayfalar/sirket-karti.aspx?hisse=" & sirketismi)
DoDoEventsLoop Until ie.readyState = READYSTATE_COMPLETE
Dim doc As HTMLDocumentSet doc = ie.document
Do Until Not ie.BusyDoEventsLoopie.document.all("page-4").ClickDoDoEventsLoop Until ie.readyState = READYSTATE_COMPLETEie.document.all("select2-ddlMaliTabloDonem1-container").Click





End Sub
site's html code



my excel link

 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Forum statistics

Threads
1,223,157
Messages
6,170,419
Members
452,325
Latest member
BlahQz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top