Hosting Microsoft Edge via WebView2Loader dll with Excel VBA

Question

My employer has created a few Excel workbooks with very detailed VBA apps that use WebBrowser (IE) embedded into a UserForm. There is a need to consider alternative approaches now that IE is reaching the end of its life cycle. Edge would be the best option, however, Selenium driver is out of scope because these workbooks are also given to outside parties.

I saw that they have managed to utilize WebView2Loader.dll in AutoHotkey scripts here https://www.autohotkey.com/boards/viewtopic.php?t=81354 and here https://www.autohotkey.com/boards/viewtopic.php?f=83&t=79868

Would there be a way to do something similar with VBA? Basically, it's a COM wrapper around that WebView2 DLL.

Answer 1

Here's an API to communicate with Chromium / EDGE from VBA without the need to install any external libraries. https://www.codeproject.com/Tips/5307593/Automate-Chrome-Edge-using-VBA

It utilizes CDP (Chrome DevTools Protocol): https://chromedevtools.github.io/devtools-protocol/