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, 2022 in Others by Kithuzzz
• 38,000 points
2,803 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, 2022 by narikkadan
• 63,600 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, 2022 in Others by narikkadan
• 63,600 points
907 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, 2022 in Others by narikkadan
• 63,600 points
2,856 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, 2022 in Others by narikkadan
• 63,600 points
2,503 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, 2022 in Others by narikkadan
• 63,600 points
1,322 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,740 points
1,225 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
3,682 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, 2022 in Others by gaurav
• 23,260 points
939 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, 2022 in Others by Edureka
• 13,690 points
1,077 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, 2022 in Others by narikkadan
• 63,600 points
1,380 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, 2022 in Others by narikkadan
• 63,600 points
1,202 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