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 vote189 views1 answer
Vb ternary
VBA
0 vote185 views1 answer
For each item in folder outlook vba
VBA
0 vote192 views1 answer
Delete rows in excel vba code
VBA
1 vote189 views2 answers
Get all column names from excel vba
VBA
3 votes194 views1 answer
Extract word in a text in excel
VBA
0 vote183 views1 answer
Vbs
VBA
0 vote187 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote188 views1 answer
Add text to combobox drop down vb
VBA
0 vote180 views1 answer
Excel vba assign shortcut key to button
VBA
0 vote179 views1 answer
Putting marquee in vb.net
VBA