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 vote130 views4 answers
How to continue formula in below line in vba code
VBA
0 vote128 views1 answer
Excel R1C1 mode
VBA
0 vote116 views1 answer
Vba check 32 or 64 bit
VBA
3 votes134 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
7 votes147 views1 answer
Excerl vba array to range
VBA
0 vote128 views1 answer
Vba sort the data Z to A
VBA
0 vote123 views1 answer
Vba option button selected
VBA
5 votes148 views1 answer
Excel vba get low byte from INTEGER
VBA
0 vote123 views1 answer
Compare dates vb
VBA
1 vote119 views2 answers
Get all column names from excel vba
VBA