How to use Excel VBA to click a web CSS button?

Question

I am creating a macro with Excel VBA that will submit an entry into an online database using information from an Excel spreadsheet. During this entry process, the macro needs to click on a CSS button. It isn't a form button, does not have an input type, no name, no id, and no source image except for a background image. I think my only hopes are either to click on the button based on the div class. Can anyone help? The button is here :

<div class="v-captiontext">
    By Ankit
</div>
<td class="v-tabsheet-tabitemcell v-tabsheet-tabitemcell-selected" style="">
    <div class="v-         tabsheet-tabitem v-tabsheet-tabitem-selected">
        <div class="v-caption" style="width: 39px;">
            <div class="v-captiontext">
                By LOT</div>
            <div class="v-caption-clearelem">
            </div>
        </div>
    </div>
</td>

I can't see any button in your HTML. Do you mean you are trying to click on one of the DIVs? — JMax
– JMax, Commented Jul 20, 2012 at 7:43

Community · Accepted Answer · 2017-05-23 12:06:12Z

-1

Thanks to Remou's answer on this thread: Use VBA code to click on a button on webpage

Here is a first stab in your issue, you could try this:

Set tags = wb.Document.GetElementsByTagname("div")

For Each tagx In tags
    If tagx.class = "v-caption-clearelem" Then
        tagx.Click
    End If
Next

Yet, I've never tried to use the Click method on a div.

edited May 23, 2017 at 12:06

CommunityBot

11 silver badge

answered Jul 20, 2012 at 7:46

JMax

26.7k12 gold badges74 silver badges89 bronze badges

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

Collectives™ on Stack Overflow

How to use Excel VBA to click a web CSS button?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related