ballgnm
New Member
- Joined
- Jan 16, 2023
- Messages
- 12
- Office Version
- 2021
- 2019
- 2016
- 2013
- Platform
- Windows
So I heard I can use Edge in IE mode on Windows 10 without installing seleniumbasic.
But couldn't find working script.
In this link Automating Edge Browser using VBA without downloading Selenium
An answer listed possible workarounds.
But still there is no working script.
I merged that registry and written simple webscape script and it still run on Internet Explorer.
Did someone actually managed to make it run on edge browser?
Web Scrape Example
But couldn't find working script.
In this link Automating Edge Browser using VBA without downloading Selenium
An answer listed possible workarounds.
But still there is no working script.
I merged that registry and written simple webscape script and it still run on Internet Explorer.
Did someone actually managed to make it run on edge browser?
Web Scrape Example
VBA Code:
Sub WebScraping()
Dim url As String
Dim IE As Object
Dim html As Object
Dim element As Object
Dim i As Integer
url = "https://www.yahoo.com"
Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True
IE.Navigate url
' Wait for the page to load completely
Do While IE.Busy Or IE.ReadyState <> 4
DoEvents
Loop
Set html = IE.Document
i = 1
For Each element In html.getElementsByClassName("ntk-footer-link")
Cells(i, 1).Value = element.innerText
i = i + 1
Next element
IE.Quit
Set IE = Nothing
End Sub