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 vote367 views1 answer
Thread sleep vb
VBA
22 votes521 views1 answer
Xlvba check for folder
VBA
0 vote365 views1 answer
Vba shape transparent
VBA
1 vote372 views1 answer
Vba format string as cash
VBA
0 vote355 views1 answer
Remove series name from legendvbnet
VBA
3 votes387 views1 answer
Excel insert blank row for value change in column
VBA
0 vote378 views1 answer
Group controls programmatically vb
VBA
1 vote393 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
0 vote385 views1 answer
Vba add shape oval
VBA
0 vote377 views1 answer
Excel vba hide gridlines
VBA