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 vote241 views1 answer
Vba first cell in range
VBA
1 vote178 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote222 views1 answer
Vba createparameter null
VBA
0 vote229 views1 answer
Vbnet line chart showing extra space
VBA
0 vote252 views1 answer
Columns dont autoresize on program start vb.net
VBA
3 votes238 views1 answer
Excel insert blank row for value change in column
VBA
0 vote240 views1 answer
Excel VBA web scraping
VBA
0 vote254 views1 answer
Test if form is open vb
VBA
0 vote245 views1 answer
Send text to clipboard vb.net
VBA
0 vote271 views1 answer
Programmatically copy data from one workshet to another excel
VBA