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 vote196 views1 answer
Change "location" of binding navigator vb
VBA
0 vote191 views1 answer
Switch pictures with buttons vb.net
VBA
5 votes209 views1 answer
Excel vba left word from Long Integer
VBA
0 vote211 views1 answer
Vba foreach 2d array
VBA
1 vote212 views1 answer
Set font for ms chart vb.net
VBA
0 vote196 views1 answer
Vbs write file
VBA
0 vote211 views1 answer
Ribbon show/hide
VBA
1 vote228 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
0 vote195 views1 answer
Check range is in another range vba
VBA
0 vote205 views1 answer
Open file dialog in vb.net
VBA