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 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |