Excel VBA to click item in html div class

Question

I'm a newbie working in my first web automation with Excel VBA. I was able to make progress so far but got stuck with trying to click on what looks like a button on the website. Please let me know if you can help me, I appreciate it. Thank you! The particular element is within the a tag in the below html code:

<div class="sh-c-btn-group">
    <input name="pf.ok" type="hidden" value="">
    <input name="pf.cancel" type="hidden" value="">
    <a title="Sign In" class="sh-c-btn sh-c-btn--primary" onclick="postOk();">Sign In</a>
</div>

I did try the getElementsByName("pf.ok")(0).Click but nothing happens -- index # (1) threw an error -- also tried getElementsByClassName("sh-c-btn sh-c-btn--primary").Click unsuccessfully — DWP
– DWP, Commented Jul 7, 2019 at 15:58
It just be tied to the onclick event. Try using div.FireEvent "onclick". This is a good reference. stackoverflow.com/questions/31221853/… — Jenn
– Jenn, Commented Jul 7, 2019 at 16:43

user6585761 · Accepted Answer · 2019-07-07 21:04:23Z

1

You can avoid looping by using the querySelector method...

HTMLDoc.querySelector("a[title='Sign In']").click

answered Jul 7, 2019 at 21:04

user6585761

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

Comments

DWP · Accepted Answer · 2019-07-07 16:44:40Z

1

Jenn & Jumpgroup, thanks so much for the help :) managed to do it with the following loop by getting the title and classname:

Dim HTMLas As MSHTML.IHTMLElementCollection
Dim HTMLa As MSHTML.IHTMLElement

Set HTMLas = HTMLDoc.getElementsByTagName("a")

For Each HTMLa In HTMLas
    If HTMLa.getAttribute("title") = "Sign In" And HTMLa.getAttribute("classname") = "sh-c-btn sh-c-btn--primary" Then
        HTMLa.Click
    Exit For
    End If
Next HTMLa

answered Jul 7, 2019 at 16:44

DWP

1051 silver badge11 bronze badges

Comments

Jumpgroup · Accepted Answer · 2019-07-07 16:16:04Z

0

This code loops until the page is loaded: Do DoEvents Loop Until objIE.readystate = 4

answered Jul 7, 2019 at 16:16

Jumpgroup

1711 silver badge6 bronze badges

1 Comment

DWP Over a year ago

I've put in the loop until the page is fully loaded and am able to fill out several forms after the page is fully loaded. But somehow can't get that one item to click.

Collectives™ on Stack Overflow

Excel VBA to click item in html div class

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related