Excel VBA Selenium Basic ChromeDriver - Removing "Save Password" and "Restore Pages" popup

[mattmc419]

Hey guys,

I have an Excel VBA script that uses Selenium Basic ChromeDriver to login and navigate a website.

I'm trying to make it so that Chrome's popup prompts in the right corner asking either to "Save password" or "Restore Pages" don't appear.

Save.jpg
Restore.jpg

My attempt is below, but it isn't working for either case.

Sub ChromeDriverTest()
    Dim bot2 As Selenium.ChromeDriver
    Set bot2 = New ChromeDriver
    bot2.SetCapability "goog:chromeOptions", "{""excludeSwitches"": [""enable-automation""], ""args"":[""--start-maximized"",""--hide-scrollbars"", ""user-data-dir=C:\\ChromeTest"",""--disable-notifications"",""--no-sandbox"",""--no-first-run"",""--no-service-autorun"",""--password-store=basic""]}"
    bot2.SetPreference "profile.default_content_setting_values.notifications", 2
    bot2.SetPreference "credentials_enable_service", False
    bot2.SetPreference "profile.password_manager_enabled", False
    bot2.Timeouts.ImplicitWait = 2000

Unfortunately still always getting the "Save Password" prompt. And the "Restore pages?" prompt continues to happen after cases where ChromeDriver is stopped suddenly in the previous run.

Any help is appreciated!

[kaasplankje]

What is missing is the web site where you are trying to log in. You have to inject the html there with your login credentials in order to make it work.

[mattmc419]

Hi kaasplankje,

I do have additional code below that, which logs into the website successfully.

It's after the login occurs that the "Save password?" box pops up. The "Restore pages?" happens right when ChromeDriver launches.

It's just that I'm assuming whatever code is going to prevent those from showing up will be in the ChromeDriver initialization section prior to the

bot2.Start "Chrome"
bot2.Get (link)

and onwards.

Hopefully that makes sense.

[kaasplankje]

The issue is that selenium opens a sandboxed version of chrome, so it does not behave as you may be used to.
I still believe this could be solved but then at least provide the name of the web site. Credentials not needed.

[mattmc419]

Definitely appreciate your help! The link where the login occurs is https://www.overstock.com/login

[kaasplankje]

Following code does the trick for me:

Sub Website_login()
 
Dim Driver As New Selenium.ChromeDriver
Set Driver = CreateObject("Selenium.ChromeDriver")

Dim loginname As String
Dim password As String

loginname = "loginname" 'adjust freely
password = "pw"         'adjust freely

Driver.Get "https://www.overstock.com/login"
Driver.Window.Maximize
Driver.FindElementByXPath("/html/body/div[1]/div[3]/div/div[4]/div[2]/form/div[1]/input").SendKeys loginname
Driver.FindElementByXPath("/html/body/div[1]/div[3]/div/div[4]/div[2]/form/div[2]/input").SendKeys password
Driver.FindElementByXPath("/html/body/div[1]/div[3]/div/div[4]/div[2]/form/div[3]/button").Click

MsgBox "Click to proceed"

End Sub

[mattmc419]

Hmm, does that not give you the Chrome-generated "Save password" box in the top right after the login completes?

I have to clear cookies from time to time for my application, so just hitting "Never" once doesn't stop it.

Hoping there's some additional code that can make it just never prompt to save the password.

[kaasplankje]

Perhaps you are using an extension in chrome that causes this?