How to turn off security prompts in VBA Excel when navigating to secure websites with

Question

How to turn off security prompts in VBA Excel when navigating to secure websites with

Whenever I'm trying to load a website, a security warning pops up asking:

"Do you want to view only the webpage content that was delivered securely?"

This popup is causing errors in my code. Is there a way to disable it using VBA?

Thank you.

Here's the code snippet:

Sub Start()

Dim ie As New InternetExplorer
Dim doc As HTMLDocument

ie.Visible = True

ie.navigate ("https://mywebsite.com")
ie.FullScreen = True
Do
DoEvents
Loop Until ie.readyState = READYSTATE_COMPLETE
Set doc = ie.document

doc.getElementById("navMenu2").Click

javascript selenium selenium-webdriver selenium-ide

Answer 1

Answer №1

The reason behind the warning message is that you are on a secure SSL page (https protocol) trying to load non-secure content (http protocol).

To resolve this issue, you can take one of the following approaches:

Access your website using http instead of https -
```
ie.navigate("http://mywebsite.com")
```
Address the security vulnerabilities on your website and avoid loading unsecured content when accessed via https.

If you need to fix it temporarily for testing purposes, you can modify the settings in your test browser:

Go to Tools -> Internet Options -> Security

Select the "Security" tab -> Click on the "Custom Level" button

In the "Miscellaneous" section, change “Display mixed content” to Enable.

Answer 2

The reason behind the warning message is that you are on a secure SSL page (https protocol) trying to load non-secure content (http protocol).

To resolve this issue, you can take one of the following approaches:

Access your website using http instead of https -
```
ie.navigate("http://mywebsite.com")
```
Address the security vulnerabilities on your website and avoid loading unsecured content when accessed via https.

If you need to fix it temporarily for testing purposes, you can modify the settings in your test browser:

Go to Tools -> Internet Options -> Security

Select the "Security" tab -> Click on the "Custom Level" button

In the "Miscellaneous" section, change “Display mixed content” to Enable.

How to turn off security prompts in VBA Excel when navigating to secure websites with

Answer №1

Similar questions

Sliding out list elements with jQuery ladder effect

Horizontal line chart in Chart.js or a customized version of the horizontal bar chart

What is the method to fetch CSS properties in relative units like percentages and ems using the .css() function with the selector "$("selector")"?

How can RobotFramework extract and verify the text within each span element of an alert?

What is the best way to trigger an event in VueJS?

detect and handle errors when deploying the Node.js function

Modifying characteristics of a duplicated object will affect every object

Navigate to the following div container upon user interaction?

Troubleshooting UV Mapping Problem in THREEJS JSON Model

Generate star icons dynamically within a div using C# and MSSQL data to determine the number of stars

Help with enabling the recognition of backspace key in JavaScript?

Incorporating an HTML element into a Vue template

What is the recommended Firefox version that works seamlessly with Selenium Webdriver 3.6.0?

Navigating to a New URL in Robotframework Without Closing the Browser After Working on the Old URL

Simultaneous running of two independent Python scripts using the subprocess module within the parent Python script

Token not provided (Vue Stripe)

Adjustable height for text input field

What is the best way to navigate to a different page without triggering the default behavior with prevent

Conceal the command prompt when using Selenium with ChromeDriver

Updating to Angular 6 from backbone