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

2 votes152 views2 answers
Constructor vb.net
VBA
0 vote179 views1 answer
Vba check if class implements interface
VBA
0 vote176 views1 answer
Vba html document reference
VBA
0 vote180 views1 answer
VBA
VBA
0 vote162 views1 answer
Excel vba formatconditions positive
VBA
2 votes123 views2 answers
Vba exit loop
VBA
0 vote187 views1 answer
Delete all controls in an area vb
VBA
0 vote181 views1 answer
Excel vba paste all to each sheet in workbook
VBA
0 vote169 views1 answer
Send text to clipboard vb.net
VBA
4 votes173 views2 answers
Vba create folder if not exist
VBA