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

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Forum statistics

Threads
1,223,893
Messages
6,175,248
Members
452,623
Latest member
cliftonhandyman

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