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

3 votes131 views1 answer
Excel vba make long from two shorts
VBA
0 vote148 views1 answer
Dynamically change drop down list visual basic
VBA
1 vote165 views1 answer
Excel vba convert text YYYYMMDD to date
VBA
4 votes147 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
6 votes138 views1 answer
Excel vba check if a string only contains alpha characters
VBA
0 vote136 views1 answer
Vba option button selected
VBA
0 vote138 views1 answer
Vba compare strings
VBA
1 vote129 views1 answer
Excel vba saveas force overwrite
VBA
4 votes140 views2 answers
Vba array length
VBA
0 vote139 views1 answer
Vbnet check if number is even or odd
VBA