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 vote273 views1 answer
Vba cell all borders
VBA
0 vote244 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote267 views1 answer
VBA
VBA
0 vote235 views1 answer
Vbnet check if string is only symbols
VBA
0 vote314 views1 answer
Find control with name vb
VBA
1 vote251 views1 answer
Vbs run
VBA
1 vote229 views1 answer
Textbox find and replace vb
VBA
0 vote247 views1 answer
Excel last used row
VBA
0 vote224 views1 answer
Vba createparameter null
VBA
1 vote246 views1 answer
How to remove zeros in excel
VBA