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 vote120 views1 answer
Vba collection key list
VBA
1 vote152 views1 answer
Perform http request in vb.net
VBA
15 votes124 views1 answer
Excel vba wait
VBA
0 vote124 views1 answer
Excel vba hide gridlines
VBA
6 votes124 views1 answer
Excel vba check if a string only contains alpha characters
VBA
0 vote133 views1 answer
Excel vba DisplayAlerts
VBA
0 vote125 views1 answer
How to carry text to the next line in a label in vb.net
VBA
4 votes134 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
0 vote122 views1 answer
Get month number from month name vbnet
VBA
0 vote138 views1 answer
Vb run command
VBA