Tags
Author: Zeki Gürsoy - Replies: 1 - Views: 2801
Msxml.XMLHTTP & HTMLDocument ile tablo verilerini alma

[code=vba]
Sub Get_Table_From_HTML()
'Dim doc As New HTMLDocument ' Microsoft HTML Object Library

Set HTTP = CreateObject("MSXML2.XMLHTTP")
Set doc = CreateObject("HTMLFile")

HTTP.Open "get", _
"https://www.isbank.com.tr/fiyatoran/FiyatTabloGoster.asp?trkd=*YTF&tip=HTML", False
HTTP.send

doc.write (StrConv(HTTP.responsebody, vbUnicode))

Set tbl = doc.getElementsByTagName("table").Item(0)

For i = 0 To tbl.Rows.Length - 1
For j = 0 To tbl.Rows(i).Cells.Length - 1