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
  • Hello All,

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

    Regards,

    Dnyanadeo Jagadale. 

    Seems like 'Microsoft Internet Controls' and 'Microsoft HTML Object Library' had been "removed" from 'References'. Adding them should resolve the problem.
    Wednesday, October 7, 2020 5:10 PM
  • Internet Explorer is being discontinued so MS Internet Controls will no longer work. 
    Saturday, October 10, 2020 11:26 AM
  • seems really helpful to me.

    Thanks 


    Saturday, November 21, 2020 6:26 AM