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 vote136 views1 answer
How to format a textbox as date vb net
VBA
0 vote144 views1 answer
Switch pictures with buttons vb.net
VBA
0 vote140 views1 answer
Vbscript for loop
VBA
0 vote142 views1 answer
Excel vba prevent saving workbook
VBA
8 votes265 views1 answer
Vba make a short integer from two bytes
VBA
0 vote144 views1 answer
Ribbon show/hide
VBA
0 vote146 views1 answer
Excel R1C1 mode
VBA
0 vote156 views1 answer
Add text to Shape VBA
VBA
0 vote144 views1 answer
Vba static variable
VBA
0 vote144 views1 answer
Vba nested dictionary
VBA