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 vote125 views1 answer
Excel vba automatic calculation
VBA
0 vote120 views1 answer
Vba find sub dictionary
VBA
0 vote119 views1 answer
Excel vba saveas no prompt for overwrite
VBA
0 vote127 views1 answer
Return na vba
VBA
1 vote147 views1 answer
Perform http request in vb.net
VBA
0 vote118 views1 answer
Convert unix to date vba
VBA
1 vote134 views1 answer
How to remove zeros in excel
VBA
1 vote107 views1 answer
How to do error handling in access vba
VBA
1 vote131 views1 answer
Vba login website
VBA
8 votes236 views1 answer
Vba convert 2 bytes to an integer
VBA