Element not interactable with Selenium Excel VBA when using SendKeys

Question

I am trying to login to a site and I am using FindElementById. In the following code the first part of using SendKeys works well but when trying to use the same technique for the password field, I get an error message which tells me that the element is not interactable

Sub Test()
Dim bot As New WebDriver

With bot
    .AddArgument "--disable-notifications"
    .Start "Chrome", "https://www.excelforum.com/excel-programming-vba-macros/"
    .Get "/"
    
    .FindElementById("navbar_username").SendKeys "username"
    .FindElementById("navbar_password").SendKeys "password"
    '.FindElementByName("vb_login_password").SendKeys "password"
    Stop
End With
End Sub

A good reproducible example with clear error message and location (+). Would have benefited from using snippet tool to share the html for the relevant node. — QHarr
– QHarr, Commented Dec 12, 2019 at 7:42
@QHarr sharing the html is necessary when there is no url but I have attached the url in the code itself so using Inspect would be more useful. — YasserKhalil
– YasserKhalil, Commented Dec 12, 2019 at 8:44
I love having the url present but not everyone may be able to access it. In this case it looks like a pretty accessible one. It was just an observation/suggestion. I was already overjoyed at having a reproducible example hence the upvote. — QHarr
– QHarr, Commented Dec 12, 2019 at 8:46

undetected Selenium · Accepted Answer · 2019-12-12 07:36:31Z

2

You were pretty close. The Password field with id attribute as navbar_password is having the property:

style="display: none;"

So you won't be able to interact with the element.

To send a character sequence both to the User Name and Password field you can use either of the following Locator Strategies:

Using FindElementById():

.FindElementById("navbar_username").SendKeys "username"
.FindElementById("navbar_password_hint").SendKeys "password"

Using FindElementByCss():

.FindElementByCss("input#navbar_username").SendKeys "username"
.FindElementByCss("input#navbar_password_hint").SendKeys "password"

Using FindElementByXPath():

.FindElementByXPath("//input[@id='navbar_username']").SendKeys "username"
.FindElementByXPath("//input[@id='navbar_password_hint']").SendKeys "password"

References

You can find a couple of revelant discussions in:

edited Dec 12, 2019 at 7:36

answered Dec 12, 2019 at 7:30

undetected Selenium

194k44 gold badges304 silver badges387 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

YasserKhalil Over a year ago

Thanks a lot. It worked when I run the code step by step so I found out that I have to wait a little before sending the data to password field.

YasserKhalil Over a year ago

How can I make the waiting is restricted to the element when it is available? I mean loop until element is ready to receive the data.

undetected Selenium Over a year ago

@YasserKhalil Gimme some time, let me look at the VB code, then I will get back to you

Raghavendra Phayde · Accepted Answer · 2019-12-12 04:11:06Z

1

Try referring this webpage

The page you are trying to access has added a web element over another web element. i.e web element of id navbar_password_hint over web element of id navbar_password. Try referring above link to solve your problem.

edited Dec 12, 2019 at 4:11

answered Dec 12, 2019 at 3:44

Raghavendra Phayde

631 silver badge8 bronze badges

1 Comment

YasserKhalil Over a year ago

Thanks a lot. It seems only I have to put a waiting line before what you suggested.

Whizdom Trainings · Accepted Answer · 2019-12-12 05:03:36Z

1

This happens when the element state is not clickable. You have to use webdriver wait property and make sure that element state is clickable

 WebDriverWait wait= new WebDriverWait(driver, 10);
    WebElement e= wait.until(ExpectedConditions.elementToBeClickable(By.xpath("xpath_of_element")));
    e.click();

answered Dec 12, 2019 at 5:03

Whizdom Trainings

611 silver badge2 bronze badges

Collectives™ on Stack Overflow

Element not interactable with Selenium Excel VBA when using SendKeys

3 Answers 3

References

3 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

References

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related