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 vote183 views1 answer
Vb run command
VBA
0 vote180 views1 answer
Vba find sub dictionary
VBA
1 vote166 views1 answer
Vba declare api 64 bit 32 bit
VBA
0 vote186 views1 answer
Excel vba convert cells address
VBA
0 vote189 views1 answer
Tester si une case est vide vba
VBA
0 vote167 views1 answer
Excel vba join variant array
VBA
0 vote213 views1 answer
Vbnet add axis labels to chart
VBA
0 vote204 views1 answer
Vba cell all borders
VBA
1 vote179 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
0 vote165 views1 answer
How to set location and size of new from vb
VBA