Forum Discussion

philipmikheikin's avatar
philipmikheikin
Brass Contributor
Dec 29, 2021

vba start edge

hi. i have cannt open an edge from vba.  have no experience at this, just watching tutorials on youtube. did some googling, and still cannot make it.    this a code i am folowing from youtube...
developer
excel
Macros and VBA
NowshadAhmed's avatar
NowshadAhmed
Iron Contributor
Dec 30, 2021
Have you tried using power query to get the information from a particular link?
It's in the Data tab. I'm sure you will love it.
Use the Data import wizard to pull information from the link on to excel. Then use functions or macro to process your data.
philipmikheikin's avatar
philipmikheikin
Brass Contributor
Jan 20, 2022
i ma familiar with power query a little, did get some info from there before. i dont know how to get links in PQ. couse each item comes from its own links. i dont know how to get hundreds of links in pq, or how to to request a link or search for items
  • jimhubbard's avatar
    jimhubbard
    Copper Contributor
    Feb 08, 2023
    the "the driver failed to open the listening port 127.0.0.1:55981 within 10sec" error likely means that you have the i ncorrect version of the webdriver installed. Double-check your browser and webdriver version numbers to make sure they are the same.
    • RickyBologna's avatar
      RickyBologna
      Copper Contributor
      Aug 25, 2023

      jimhubbard  you can find the latest EDGE library for Selenium on the following link:

      https://developer.microsoft.com/en-us/microsoft-edge/tools/webdriver/

       

      Remember to rename the file to >edgedriver.exe< and copy it under the directory C:\Users\%username%\AppData\Local\SeleniumBasic

       

      I hope that solve your problem.

      • KallilE's avatar
        KallilE
        Copper Contributor
        Jul 27, 2024

        RickyBologna Thanks, this solved my error. Had to copy the file to (...)\AppData\Local\SeleniumBasic; and also not just update the EdgeDriver, but the SeleniumBasic (because i was getting Error "This version of Microsoft Edge WebDriver only supports Microsoft Edge version 124 Current browser version is 123.0.2420.97", even though i had it updated; but i hdant copied the file, the documents/installation are not clear about this NEEDED STEP to use MS Edge Driver. So, THANK YOU.

Resources