Can VBA work with Microsoft Edge?
My boss recently decided to have his email in Microsoft Edge, using the Office 365 webmail interface.
I think this is the first time in history that I've been asked to write a macro to automate an email operation with another program.
I know you can copy and paste from other programs and it works fine but copying and pasting from Microsoft Edge is not working and, from what I have discovered, can't be done (or should I say "won't work") via VBThe macro just doesn't recognize any command to paste. This is frustrating because the Office 365 webmail interface will automatically copy the URL from the mail message to the clipboard on the website for that mail so we don't even have to do anything.
We want to make a macro that copies the mail message into Microsoft Edge. We want the macro to work because the mail we are receiving from our company's intranet is now in Microsoft Edge and if we want to see who sent the mail or respond to the mail, we have to copy and paste the email into the webpage for that mail which could be on any number of websites (it's possible to forward the mail to more than one place).
For example, the office365 webmail takes over the address bar so if you wanted to post the message and the mail has an attachment, it pops up an additional page to upload the attachment. This is where the macro fails and I was trying to get it to paste from any application or even from the clipboard in general but it won't work. I suspect there is a way to do this through code.
This is the script that I have so far and it does everything I need it to do except the pasting from Microsoft Edge. Is there a way to change it to work with Edge? Or is there a way to send the macro to Edge if it works in Excel. Thanks in advance! Sub x(). Dim d1,d2,w As String. Dim y As Variant. Y = Worksheets("Test").Range("A1").Value
D1 = Worksheets("Test").Range("B1").Value
D2 = Worksheets("Test").Range("C1").Value
W = Worksheets("Test").Range("D1").Value
Workbooks.Open y & " " & d1 & " " & d2 & " " & w & ".
Does Microsoft have a macro?
Or a software program?
I don't think it's
-----. Mitchtbaum. The comments on that post are very interesting; it looks like MS's. Engineering/IT culture, in contrast to others, is not always well-aligned with. The business's goals. Peterwwillis. Yes, but the business should know that. It's not a bad thing, but the business can't afford to fix the problem if the engineering department doesn't care. Enough to stop putting things into production without testing it. Fiatjaf. When I read this I immediately thought "The business is using it, then.
How do I automate my Edge browser?
I'd like to automate the browser so I can open a link and send the required response, however, none of the suggested methods of "Automatically open URL in IE Edge or Mozilla Firefox on PC", "Automatically Open Browser on Windows PC" or "Windows 10: Automatically open any app in desktop" seem to work.
I've tried using WshShell.Run /WScript "" "C:Program Files (x86)MicrosoftEdgeApplicationSettingsInternetSettings.exe" /SetAppLaunchedToInternet" /App /ForceReopenURL "%URL%" but when I do a test like: "test", then the app never appears in the taskbar and when I go to the Start menu and click the app it says "Windows error message" (but when I start from Explorer it opens).
And I know it probably goes against Microsoft's policies and I should go directly to the App Store and download it, but I'm in a very restrictive work network where I can't install anything without approval and this tool will take me days to develop and if it doesn't work, well, I lose that work and all my time on this project, so I really want this tool to work. In addition to that, if Microsoft knows their Windows 10 update won't work even though I already downloaded it and I have to update Windows again, so that's a bit weird too. This answer came from the Windows support department. For posterity, here is the answer as found in the forum, the link between the two posts has been removed: "We will add functionality to the Windows Server, and we will release a new version of the Windows Server (update 1 from 11-14) in August/September 2024 with this. This is the first update to Windows after you get an official release of the Windows 10 November Update for the Creators Update. The next Windows Server release after will have the feature you're looking for. I expect there may be other changes that must occur for you to be able to use the feature that you're interested in."
This answer is a little vague since Microsoft are generally quiet about the server updates. But, this is a big deal if you want to have this working with the latest Windows 10 build.
Related Answers
How do I disable macros in group policy?
This article provides a step-by-step guide to turn off macros in Of...
Is Excel macro a skill?
In the past couple of years I've noticed people refer to two...
Does Excel 2016 have Macros?
After I used the Microsoft Office Assistant tool to clean up my Excel spreads...