none
VBA for Microsoft Edge RRS feed

  • Question

  • Hello All,

     I want to open url in Microsoft Edge or Chrome. Please help me. 

    Regards,

    Dnyanadeo Jagadale. 

    Tuesday, December 25, 2018 11:53 AM

All replies

  • download and install seleniumBasic https://florentbr.github.io/SeleniumBasic/

    if this awnser helped you please vot for my post and mark it as awnsered ! merry christimas!

    Tuesday, December 25, 2018 3:49 PM
  • VBA doesn't directly support other browsers.  You'll need to use use a 3rd party addin.  Almost all browsers can be controlled with a Selenium webdriver.  Someone did a VBA .NET COM DLL called SeleniumBasic that uses Selenium to control the web browser.  This release is dated.  You need to have a webdriver compatible with browser version.  If you update the Chrome and Edge drivers it seems to work fine.  SeleniumBasic installs at:

    C:\Users\<user>\AppData\Local\SeleniumBasic

    Get correct Chrome webdriver and replace it.  It has to have same name.

    Get correct Edge webdriver and replace it.  You'll need to rename it.

    Firefox doesn't work.

    ' Add Reference to Selenium Type Library '

    Private Sub Use_Chrome() Dim driver As New ChromeDriver driver.Get "https://www.google.co.uk" driver.Quit End Sub Private Sub Use_Edge() Dim driver As New EdgeDriver driver.Get "https://www.google.co.uk" driver.Quit End Sub




    • Edited by mogulman52 Tuesday, December 25, 2018 4:46 PM
    Tuesday, December 25, 2018 4:40 PM