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 vote166 views1 answer
Como ler subitem de um array em json usando vbnet
VBA
3 votes176 views2 answers
Vba active workbook path
VBA
0 vote168 views1 answer
Create links in msgbox in vb
VBA
0 vote160 views1 answer
Vba string start with
VBA
8 votes292 views1 answer
Vba make a short integer from two bytes
VBA
2 votes143 views2 answers
Constructor vb.net
VBA
0 vote161 views1 answer
Switch pictures with buttons vb.net
VBA
0 vote157 views1 answer
Vba sheet visible
VBA
-1 vote161 views1 answer
Vba code to add new column in table
VBA
0 vote162 views1 answer
Vba sheet hide unhide
VBA