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
site's html code
my excel link
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
my excel link