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 vote209 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
0 vote231 views1 answer
Vba code to select image in sheet
VBA
3 votes242 views1 answer
Extract word in a text in excel
VBA
0 vote223 views1 answer
Add text to Shape VBA
VBA
0 vote281 views1 answer
Application.ExecutablePath VB.NET
VBA
0 vote202 views1 answer
Do until vb.net
VBA
0 vote208 views1 answer
Excel vba existence of a file
VBA
1 vote207 views1 answer
Excel vba get column name from number
VBA
0 vote152 views1 answer
Excel autofilter vba
VBA
0 vote245 views1 answer
Excel vba round to whole number
VBA