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 vote303 views2 answers
S yyyy-MM-dd em vb net
VBA
0 vote281 views1 answer
Excel vba disable screen update
VBA
0 vote277 views1 answer
Excel vba disable keyboard input
VBA
0 vote391 views1 answer
Vba change active sheet
VBA
0 vote282 views1 answer
Vba excel parser xml
VBA
4 votes273 views2 answers
Excel vba last column with data
VBA
0 vote279 views1 answer
VBA is form loaded
VBA
0 vote290 views1 answer
Vba registry settings
VBA
0 vote304 views1 answer
Vbs run with cscript
VBA
2 votes267 views1 answer
Vba round number
VBA