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 vote226 views1 answer
Vbscript check if string is empty
VBA
0 vote240 views1 answer
.net dark title bar
VBA
2 votes217 views1 answer
Excel vba date to string conversion
VBA
8 votes318 views1 answer
Excel vba determine number of elements in a 2D array
VBA
0 vote246 views1 answer
Vba code to select image in sheet
VBA
22 votes535 views1 answer
Xl vba check for folder
VBA
-1 vote240 views1 answer
Code for reading letters only in vb 6
VBA
0 vote221 views1 answer
Excel vba assign shortcut key to button
VBA
0 vote253 views1 answer
Send text to clipboard vb.net
VBA
20 votes535 views1 answer
Excel vba factorial
VBA