trying to click button in Chrome using VBA

Question

As a newbie writing Macro to automate Chrome (v 75.0.3770.100) using Selenium Basic ChromeDriver (v 75.0.3770.140) in Excel (2013) VBE, I'm trying to find a way to click a button. The id keeps changing. Here's the HTML:

<td align="left">
<button type="submit" id="nHuPf" class="login_btn y-btn-primary z-button">Login</button>
</td>

I've tried this to no avail:

obj.FindElementByClass("login_btn y-btn-primary z-button").Click

' The macro starts with this:

Dim obj As New ChromeDriver

obj.Start "chrome", "   "
obj.Get "https://sh.com/backoffice"

Would appreciate any advice on how to click this button using the Selenium Type Library in Excel VBE, thanks.

I can see id="nHuPf" >> so why didn't you try FindElementByID? — YasserKhalil
– YasserKhalil, Commented Jul 15, 2019 at 3:45

QHarr · Accepted Answer · 2019-07-15 03:43:26Z

2

Try javascript to execute

obj.ExecuteScript "document.querySelector('.login_btn').click();"

answered Jul 15, 2019 at 3:43

QHarr

84.5k14 gold badges58 silver badges105 bronze badges

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

Comments

undetected Selenium · Accepted Answer · 2019-07-15 06:25:18Z

1

To click on the element with text as Login you can use either of the following Locator Strategies:

cssSelector:

driver.FindElementByCss("button.login_btn.y-btn-primary.z-button[type='submit']").Click

xpath:

driver.FindElementByXPath("//button[@class='login_btn y-btn-primary z-button' and text()='Login']").Click

answered Jul 15, 2019 at 6:25

undetected Selenium

194k44 gold badges304 silver badges387 bronze badges

Collectives™ on Stack Overflow

trying to click button in Chrome using VBA

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related