Vba detect webbrowser button click

[JudahRaion]

Hi,

I'm trying to figure how to fire an event related with a specific button pressed in an userform webbrowser.

For example, I'm trying to click in "Write" button of gmail and detect it with excel.

I know that the button have the ID: ":4s"

And what I tried was:

Private Sub UserForm_Initialize()        
    TextBox1.Value = "gmail.com"
          
    Me.WebBrowser1.Navigate TextBox1.Value
    
End Sub


Private Sub WebBrowser1_DocumentCompleted()
  
    If WebBrowser1.Document.All(":4s").******* = True Then 
[COLOR=#ff0000]        Me.WebBrowser1.Navigate "about:blank" -> just to test if it is detecting my click and is not![/COLOR]
    End If


End Sub

Can anybody help me please?

Thank you

 

[sijpie]

This is not a trivial thing to do. Once you are in the webbrowser, then Windows will not send any events ( keystrokes or mouseclicks) to Excel. These are intercepted by the current application and removed from the queu. So you would have to write a 'hook' into the Windows event queu to pick up the events and check these before passing them on. VBA? no... If you know a good C programmer he could do it, but then you're still faced with a lot of hurdles. So basically you need to rethink what you want to achieve.

 

[chuckchuckit]

Sijpie – From what you are saying in this thread, I am thinking that might be the same issue I would have to deal with if I was trying to confirm a click was successful in this thread?

https://www.mrexcel.com/forum/excel...hat-posttext-syntax-click-button-webpage.html

Thanks. -Chuck

 

[sijpie]

Possibly slightly related. But sending events to other applications is easier then intercepting events.
The issue in the other thread is interesting. I am assuming yahoo is using java or similar to call data and display it when you press the button. I've never worked with query tables though. So no help from me on that one. I'll see if i can dig up some code on the event intercept that might come in handy.

 

[chuckchuckit]

Thanks. It will be much welcomed if you find something.

Eventually hope to figure out how to click that button by not using IE (perhaps using one of the two examples there).

But then might be problems to not know if the website data has completed updating from that click, before the response is generated to be sent back to Excel.