' run search Call objBrowser.jsEval( " document.getElementsByName(""q"").form.submit()") ' fill search form (textbox is named q) Call objBrowser.jsEval( " document.getElementsByName(""q"").value=""automate edge vba""") ' evaluate javascript Call objBrowser.jsEval( " alert(""hi"")") ' navigate Call objBrowser.navigate( " ") ' Attach to any ("") or a specific page Call objBrowser.attach( " ") ' Start Browser Dim objBrowser As clsEdge ' This is an example of how to use the classes Sub runedge() Evaluate arbitrary JavaScript expressions in the context of a page and return the resultīut these functions should suffice to do basic Webscraping.Basic functions to set up the communication channel.The code implements only a very narrow set of functions:
A full documentation of the protocol can be found here. The code uses the Chrome Devtools Protocol (CDP) to communicate with the browser. Otherwise the tabs are opened in the currently running process, not the one that has been started and subsequent communication between VBA and Edge fails. Keep in mind, that all running Edge procceses must be terminated before running the code. The following solution needs no additional software, apart from a Chrome-based browser. But this requires the installation of a Webdriver, which might not be feasible in some environments. There are libraries that try to fill this gap using Selenium, see Seleniumbasic as an example. Microsoft seems uninterested in creating a drop-in replacement for the IE OLE Object. Microsoft Edge is no longer based on ActiveX technology. But Microsoft will end support for IE in the near future and wants users to move to newer browsers like Microsoft Edge. It was very easy to automate IE for tasks like Webscraping or testing from OLE-aware programming languages like VBA.
Internet Explorer classic (IE in the following) was based on ActiveX technology.
0 kommentar(er)
