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

1 vote160 views2 answers
Vba string length
VBA
0 vote162 views1 answer
Discern between file and folder given path vb.net
VBA
0 vote136 views1 answer
Vbnet make a string to unicode converter
VBA
0 vote143 views1 answer
Excel protect cells with formulas
VBA
5 votes164 views1 answer
Excel vba low word from Long Integer
VBA
2 votes150 views1 answer
Date format for ms chart vb.net
VBA
8 votes285 views1 answer
Vba make a short integer from two bytes
VBA
0 vote162 views1 answer
Filesystemobject vba reference
VBA
0 vote158 views1 answer
Search in richtextbox vb.net
VBA
0 vote146 views1 answer
Vba file size
VBA