Excel web scraping

Sub test()
Dim ie As New InternetExplorer
Dim doc As New HTMLDocument
Dim ecoll As Object

ie.Visible = True
ie.navigate "http://demo.guru99.com/test/web-table-element.php"
Do
DoEvents
Loop Until ie.readyState = READYSTATE_COMPLETE
Set doc = ie.document
Set ecoll = doc.getElementsByTagName("table")

Source: guru99.com

Similar codes

0 vote180 views1 answer
Move bindingnavigator vb
VBA
0 vote179 views1 answer
Excel vba assign shortcut key to button
VBA
32 votes347 views2 answers
Excel vba column letter
VBA
0 vote176 views1 answer
Vba parameter adodb null value
VBA
0 vote185 views1 answer
Excel vba extract year
VBA
1 vote163 views1 answer
Excel format cell as kilowatts
VBA
1 vote187 views1 answer
Vb.net get name by Selection Changed
VBA
0 vote166 views1 answer
Open application from vbnet
VBA
0 vote185 views1 answer
Putting marquee in vb.net
VBA
0 vote171 views1 answer
Handling a click event anywhere inside a panel vb
VBA