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

8 votes245 views1 answer
Excel vba determine number of elements in a 2D array
VBA
0 vote239 views1 answer
Vba cell all borders
VBA
0 vote217 views1 answer
Vba type
VBA
0 vote230 views1 answer
Excel VBA web scraping
VBA
0 vote261 views1 answer
Filesystemobject vba reference
VBA
0 vote223 views1 answer
Vbnet line graph smooth lines
VBA
0 vote218 views1 answer
Vb.net change cursor to wait
VBA
1 vote222 views1 answer
Vba compile error object required
VBA
0 vote214 views1 answer
Vbnet display all axis labels in cahrt
VBA
0 vote225 views1 answer
Vba html document reference
VBA