Can VBA work with Microsoft Edge?

I'm trying to design a small (as in 3 pages) Excel document that has a button at the end of the final page that will launch the browser to a URL specified. The problem I'm having is that even after trying different settings, I keep getting errors in Visual Basic. ?
Here is the section of code: On Error GoTo 0. ' Create new "blank" sheet. Set Sheets("sheet1") = Worksheets.Add With Sheets("sheet1").Name = "pageX" .Cells(1, 1).FormulaLocal = "C:UsersxxxxxDesktopTestPage1.html"

End With. ' Launch browser. Set WshShell = CreateObject("WScript.Shell") WshShell.Run chr(34) & "C:WindowsSystem32rundll32.exe" & chr(34) &

"C:WindowsSystem32url.dll,URLDownloadToDisk" & chr(34) & "C:UsersxxxxxDesktopTestPage1.html", vbNormalFocus The "On Error GoTo 0" is because the web browser pops up even if there are errors and I don't want that. Any help would be appreciated. Try this. Dim htmlFile As Object. Dim wshShell As Object. Dim ShellAppPath As String. ShellAppPath = "C:WindowsSystem32rundll32.exe" & "C:WindowsSystem32url.dll,URLDownloadToDisk" & Set wshShell = CreateObject("WScript.Shell") wshShell.Run ShellAppPath, vbNormalFocus Set htmlFile = wshShell.Open(FileName:=

How to automate Edge browser using Excel macros without Selenium?

In this video I will show you a working tool that can be used to automate browser Edge.

It can be used to navigate using keyboard shortcuts, copy text from the webpage and paste it into another application or clipboard. It will even show a realtime result of the automation for example an alert message that there is a new email in the inbox that the system has been notified about. It supports Edge version 62 as well as Edge canary version 1.

I made this tool with Excel because I already had everything I needed from the list above. There are more things you can add to it like using other browsers, like Safari or Firefox etc. So don't think this is limited to only Edge or only Excel macros but anything can be included to make this tool more universal.

What you get out of it. Here is a video of it in action: And here is a spreadsheet to try it out: The video shows that the automation works on two pages: Both of these pages have been tested with Firefox. You can also use them in Edge but it doesn't work as expected.

To do this, go to the Google website that you want to test. The first page that we are interested in the email box that will be at the top right corner. Click on the email button in this field.

The email address will be selected when a new window will be opened to Gmail on your phone or computer or any other device. Just type the email address or search in there.

Once the new window is opened in Gmail, click on the blue "Send mail" button and a new window will open up to the Google webmail. Now on this Google page, click on the big circle symbol on the top right corner of the page (like on the screenshot below): Now scroll down and find the green sign for "Sign Out" (like on the screenshot below). Click it once, it will close down the current window and open up a new one. You should now be on the page that tells you that "you're almost done".

How do I create a macro in Microsoft Edge?

There is not an option to create a macro in Microsoft Edge.

But I have found a solution. The "Developer Tools" tab on the menu bar brings up a set of options.

Macro Settings. New macro. Create the new macro. Open the "Developer Tools" pane and click "Macro Settings". There you will find your new macro. It will not show your newly created macros as long as the Macro pane has not opened.

To make it available for all users. Close the Developer Tools pane. Go to the Microsoft Edge menu and select "Settings". Select "Add a new feature" and search for "Edge macro". You can then add your macro there and set the group to "Default".

For your convenience; my new macro is. #macro. How can I get this into Microsoft PowerPoint? Create a document with a button to set the text: button Macro. Save the new PPT file to my desktop. Open PowerPoint, create a new presentation. Create a new slide (Title Slide). Add the button above the title, size it to fit. Open it in PowerPoint. Select "Tools" > "Macro Settings". Select "New macro". Create your new macro here and save it. ? Create a new slide (Title Slide). Now to see this in action, you could have a webpage on your phone that launches your presentation on your desktop.