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 vote244 views1 answer
Label de tableau dans des label.text en VBA
VBA
0 vote224 views1 answer
Add text to combobox drop down vb
VBA
0 vote216 views1 answer
Vba copy paste value only
VBA
0 vote293 views1 answer
Excel vba protect worksheet without password
VBA
1 vote230 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
0 vote280 views2 answers
Excel vba store array and write to sheet
VBA
0 vote241 views1 answer
Vba html document reference
VBA
1 vote236 views2 answers
Excel vba password protect
VBA
0 vote224 views1 answer
Refer to resource using string variable vb.net
VBA
3 votes239 views1 answer
Vba double quote
VBA