Trying to click submit button which as image as button vba

Question

I have been trying to click the input button on a web page using JavaScript. I have tried the following:

HTML

<input type="image" src="/img/go_button.gif">

VBA

 ' Not working 
el.click

 ' Not working

el.focus 
el.invokemember("OnClick")

JavaScript

function toggleMenu(obj, title)
{
    var internalMenu = obj.parentNode.getElementsByTagName("div").item(0);
    var d = internalMenu.style.display;
    if (d != "block") {
        internalMenu.style.display = "block";
        obj.innerHTML =
            '<IMG SRC="/images/menu-arrow-open.gif"'
            + ' border=0>&nbsp;' + title;
    } else {
        internalMenu.style.display = "none";
        obj.innerHTML =
            '<IMG SRC="/images/menu-arrow.gif" ' +
            'border=0>&nbsp;' + title;
    }
}

I have been searching Google, but I haven't found any solution yet.I've seen a method called ie.Document.parentWindow.execScript, but I'm not sure how to use it.

Is it possible to click that image button and take whatever results I want?

Which is the part of Excel in this case? If the VBA is running in Excel, how do you get the el? Are you sure you have the right element? Is the <input type="image"> a FORM's submit button? If so, why not simply submit the FORM? — Axel Richter
– Axel Richter, Commented Nov 28, 2014 at 6:52
Im sure about that .. i able to loop though each input element in the web page . i did inspect element for that button. and i pasted the html content in my question — user3114645
– user3114645, Commented Nov 28, 2014 at 10:23

QHarr · Accepted Answer · 2018-06-29 16:24:24Z

1

CSS selector

No need for a loop. Use a CSS selector of:

input[src='/img/go_button.gif']

This specifies input tag with attribute src having value '/img/go_button.gif'

CSS query:

VBA:

You apply CSS selector using .querySelector method of document

ie.document.querySelector("input[src='/img/go_button.gif']").Click

answered Jun 29, 2018 at 16:24

QHarr

84.5k14 gold badges58 silver badges105 bronze badges

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

Comments

Matteo NNZ · Accepted Answer · 2014-11-28 19:30:09Z

0

This is what I would do:

A. Get all the input elements in the page:

Set allInputs = ie.document.getElementsByTagName("input")

B. Looping through them and clicking the one which refers to the image "go":

For Each element In allInputs
    If element.getAttribute("src") = "/img/go_button.gif" Then
        element.Click
        Exit For
    End If
Next element

answered Nov 28, 2014 at 19:30

Matteo NNZ

12.8k13 gold badges63 silver badges104 bronze badges

1 Comment

user3114645 Over a year ago

Thanks for the code. But it doesnt't worked. i already tried this method .But no luck ..code simply passes that line (el.click) :(

b_dubb · Accepted Answer · 2016-10-04 20:05:39Z

0

$('input[type="image"]').trigger('click');

should do it

answered Oct 4, 2016 at 20:05

b_dubb

41413 silver badges32 bronze badges

Collectives™ on Stack Overflow

Trying to click submit button which as image as button vba

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related