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 vote320 views1 answer
Excel vba protect content
VBA
0 vote347 views1 answer
Method showalldata of object _worksheet failed vba
VBA
4 votes332 views2 answers
Vba last row
VBA
8 votes368 views1 answer
Excel vba make integer
VBA
0 vote336 views1 answer
Vbnet access System.InvalidOperationException: 'Update requires a valid UpdateCommand when passed DataRow collection with modified rows.'
VBA
0 vote363 views1 answer
Vba foreach 2d array
VBA
0 vote329 views1 answer
Vba test optional argument
VBA
0 vote324 views1 answer
VBA Loop to range
VBA
0 vote305 views1 answer
Find days in month vba
VBA
0 vote326 views1 answer
Excel vba round to whole number
VBA