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 vote141 views1 answer
Excel vba chrw max value
VBA
1 vote151 views1 answer
Vbs run
VBA
0 vote148 views1 answer
Not allow form to be resized
VBA
0 vote139 views1 answer
Excel vba scroll to cell
VBA
0 vote140 views1 answer
Vba sheet visible
VBA
1 vote95 views1 answer
How to open cmd with vbd
VBA
3 votes150 views1 answer
Excel vba change format of cell
VBA
0 vote149 views1 answer
Excel delete ever other vba
VBA
0 vote154 views1 answer
Vba simple quote
VBA
0 vote144 views1 answer
How to carry text to the next line in a label in vb.net
VBA