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 vote150 views1 answer
Excel vba delete folder
VBA
0 vote155 views1 answer
Loop through all text boxes in a form vb
VBA
1 vote155 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
1 vote158 views1 answer
Excel vba array remove first
VBA
0 vote149 views1 answer
Excel named range sum
VBA
0 vote151 views1 answer
Method showalldata of object _worksheet failed vba
VBA
4 votes158 views1 answer
VBA Deep Clone Dictionary
VBA
1 vote150 views1 answer
Excel vba unload userform
VBA
3 votes147 views1 answer
Excel vba get the workbook full file name with path
VBA
8 votes299 views1 answer
Excel vba make word from bytes
VBA