Click HTML button that has ID and Onclick via VBA

Question

I'm trying to click on a button after inputing data in this field:

<input name="termoBuscaUsuarioAprovador" id="termoBuscaUsuarioAprovador" 
style="width: 240px;" onkeydown="javascript:var keyCode = event.keyCode ? 
event.keyCode : event.which ? event.which : event.charCode; if(keyCode == 13) { 
document.getElementById('buscaResponsavel').focus(); }" onkeypress="return 
desabilita(this, event);javascript:var keyCode = event.keyCode ? event.keyCode 
: event.which ? event.which : event.charCode; if(keyCode == 13) { document.getElementById('buscaResponsavel').focus(); }" type="text" value="">

I'm using this and it seems to work:

IE.Document.getElementById("termoBuscaUsuarioAprovador").Value = "xxxxxxx" 'Name

But when I try to click on the "Search" button below, a brief loading bar appears (exacly as if I was manualy clicking the button), but it doesn't show anything, it still remaings blank.

<input name="buscaUsuarioAprovador" id="buscaResponsavel" style="width: 100px;" onclick="pesquisar_dadosUsuarioAprovador(document.getElementById('termoBuscaUsuarioAprovador').value)" type="button" value="Buscar">

The code I'm using that makes the loading bar appears is:

IE.Document.getElementById("buscaResponsavel").Click

I don't know if i'm partially triggering the button because of that "onclick", or if it has something to do with the input field.

Thank you!

Dvyn Resh · Accepted Answer · 2018-11-23 12:20:36Z

1

Its hard to answer your question without navigating webpage, but most common possibility is text box value triggers some function to perform so instead of just passing value to the text box you can use below methods Method 1:

  set Zip =  IE.Document.getElementById("termoBuscaUsuarioAprovador")
  Zip.Value = "XXXXX"   
  Dim event_onChange As Object
  Set event_onChange = ie_Doc.createEvent("HTMLEvents")
  event_onChange.initEvent "keypress", True, False
  Zip.dispatchEvent event_onChange

you can replace "Keypress" as "keydown" if it not works

Method 2:

   set Zip =  IE.Document.getElementById("termoBuscaUsuarioAprovador")
  Zip.Value = "XXXXX"
  Zip.FireEvent ("onkeypress")
or
  Zip.FireEvent ("onblur")

Hope this helps

answered Nov 23, 2018 at 12:20

Dvyn Resh

9701 gold badge6 silver badges14 bronze badges

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

1 Comment

Igor Over a year ago

Method 1 gave me an error with "ie_doc", so I replaced it with IE.Document. But when I tested the code nothing happened in the website. Method 2 neither FireEvents triggered the button.

QHarr · Accepted Answer · 2018-11-23 13:54:39Z

1

Have you tried .FireEvent to trigger the onclick?

IE.Document.getElementById("buscaResponsavel").FireEvent "onclick"

Perhaps sequence:

IE.Document.getElementById("buscaResponsavel").FireEvent "onkeypress"
'Set value however you are.....
IE.Document.getElementById("buscaResponsavel").FireEvent "onclick"

edited Nov 23, 2018 at 13:54

answered Nov 23, 2018 at 12:52

QHarr

84.5k14 gold badges58 silver badges105 bronze badges

5 Comments

Igor Over a year ago

Forgot to mention that, yes I did, it had the same effect of .click (brief loading bar, but result is blank)

QHarr Over a year ago

Did you try firing the other 2 events? Looks like needs keydown to enable focus

Igor Over a year ago

No luck. What do you mean by keydown?

QHarr Over a year ago

The other events listed in the html for the element

Igor Over a year ago

oh, ok. But no results yet.

Collectives™ on Stack Overflow

Click HTML button that has ID and Onclick via VBA

2 Answers 2

1 Comment

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related