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 vote173 views1 answer
Putting marquee in vb.net
VBA
1 vote174 views1 answer
Excel vba last row of range
VBA
3 votes174 views1 answer
Excel vba change format of cell
VBA
0 vote162 views3 answers
Write to text file vb.net
VBA
0 vote166 views1 answer
Limit combobox to list vba
VBA
0 vote165 views1 answer
Excel vba Column Name to Column Number
VBA
0 vote165 views1 answer
Vba nested dictionary
VBA
0 vote170 views1 answer
Vba range clear formatting
VBA
0 vote168 views1 answer
Excel vba copy range with filter
VBA
0 vote155 views1 answer
Do until vb.net
VBA