Trying to connect to MS Edge from an MS Access VBA form and pass the site values

Question

Hi,

I am trying to connect to MS Edge from an MS Access VBA form and pass the site values form the form.

Right now what I have works in the old IE but gets hung up in if I try to go to Edge. And by hung up I mean it opens the site at the log-in page but is stuck then in ready state 0 and needs to go to 4.

I cannot share the code but as I say it works in IE, I am just looking for what has to be changed in general to open in Edge.

Thank you

Answer 1

Hello

Thank you for your question and reaching out. I can understand you are having query\issues related to connect to MS Edge from an MS Access VBA.

Access to Edge is different then accessing of IE using VBA code.

In order to open a specific web page on Microsoft Edge, do like this:

VBA code:

CreateObject("Shell.Application").ShellExecute "microsoft-edge:http:// website name.com"

Reference :

https://learn.microsoft.com/en-us/answers/questions/843285/edge-opening-and-filling-a-webpage-through-vba

--If the reply is helpful, please Upvote and Accept as answer--