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 vote231 views1 answer
Change whcih control a user has selected vb
VBA
0 vote241 views1 answer
Vba check if class implements interface
VBA
0 vote294 views1 answer
Vba excel do not recalculate before save
VBA
0 vote226 views1 answer
Vba remove numbers from string
VBA
0 vote229 views1 answer
Vba nested dictionary
VBA
0 vote282 views1 answer
Wpf dark title bar
VBA
31 votes538 views1 answer
Vba how to convert a column number into an Excel column
VBA
0 vote365 views1 answer
Vba line feed
VBA
3 votes264 views1 answer
Extract word in a text in excel
VBA
0 vote255 views1 answer
Vba random number
VBA