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 vote338 views1 answer
Excel vba StartUpPosition
VBA
4 votes308 views1 answer
Excel formula for last non-empty cell in a column
VBA
0 vote362 views1 answer
Excel vba first column in range
VBA
0 vote346 views1 answer
Vba min
VBA
0 vote341 views1 answer
Excel vba remove formatting from cell
VBA
0 vote321 views1 answer
Excel R1C1 mode
VBA
5 votes343 views1 answer
Xl vba double quotes in string literal
VBA
0 vote353 views1 answer
Tester si une case est vide vba
VBA
0 vote328 views1 answer
Vb run command
VBA
0 vote317 views1 answer
How to use VBA to add new record in MS Access?
VBA