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 vote235 views1 answer
Vb.net visible property dgv collumn not working
VBA
0 vote212 views1 answer
Excel vba disable alerts
VBA
1 vote236 views2 answers
Excel vba password protect
VBA
0 vote216 views1 answer
Backspace key has stopped working visual studio
VBA
0 vote221 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
0 vote250 views1 answer
Excel vba DisplayAlerts
VBA
0 vote249 views1 answer
VBA Loop to range
VBA
0 vote219 views1 answer
Excel vba disable screen update
VBA
4 votes271 views1 answer
Excel vba how to get a range's full address including sheet name
VBA
0 vote249 views1 answer
Remove first character from string vb
VBA