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

1 vote230 views1 answer
Vbscript convert ascii code to character
VBA
0 vote251 views1 answer
Excel vba join variant array
VBA
0 vote296 views1 answer
Application.ExecutablePath VB.NET
VBA
0 vote243 views1 answer
Not allow form to be resized
VBA
0 vote223 views1 answer
Create new worksheet excel visual basic
VBA
1 vote264 views1 answer
Excel how to format bytes as KB, MB, GB
VBA
0 vote241 views1 answer
Loop through lines in text file vb net
VBA
0 vote232 views1 answer
Vba line feed
VBA
0 vote229 views1 answer
Excel vba disable copy paste
VBA
5 votes190 views1 answer
Vba array worksheet.index
VBA