Hosting Microsoft Edge via WebView2Loader dll with Excel VBA

0 votes

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.

Sep 27 in Others by Kithuzzz
• 20,660 points
300 views

1 answer to this question.

0 votes

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/

answered Sep 29 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

Unhide rows in Excel with VBA

Paste this code into a module of ...READ MORE

answered Oct 1 in Others by narikkadan
• 37,660 points
67 views
0 votes
1 answer

How to reference Microsoft.Office.Interop.Excel dll?

Use NuGet (VS 2013+): The NuGet package manager ...READ MORE

answered Oct 9 in Others by narikkadan
• 37,660 points
131 views
0 votes
1 answer

How to insert a picture into Excel at a specified cell position with VBA

Try this: With xlApp.ActiveSheet.Pictures.Insert(PicPath) With ...READ MORE

answered Oct 24 in Others by narikkadan
• 37,660 points
119 views
0 votes
1 answer

How To Use VBA To Share Excel File With Fellow Office User?

PowerApps were referenced; if you have a ...READ MORE

answered Oct 28 in Others by narikkadan
• 37,660 points
41 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
449 views
0 votes
1 answer

How to load file to Excel Power query from SFTP site

Currently, I don't think there is a ...READ MORE

answered Dec 3, 2018 in Power BI by Upasana
• 8,620 points
2,202 views
0 votes
1 answer

Using VBA Excel to create a gramatically correct list

The Excel AND function is a logical ...READ MORE

answered Feb 9 in Others by gaurav
• 22,040 points
68 views
0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
201 views
0 votes
1 answer

How to print an Excel Sheet using VBA with Nitro PDF Creator in Excel 2016

you can use the built-in excel facilities ...READ MORE

answered Sep 24 in Others by narikkadan
• 37,660 points
113 views
0 votes
2 answers

Excel VBA App stops spontaneously with message "Code execution has been halted"

Solution Press the "Debug" button in the popup. Press Ctrl+Pause|Break twice. Hit ...READ MORE

answered Sep 29 in Others by narikkadan
• 37,660 points
63 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP