VBA "IWebBrowser 2 Failed" on button click

[Darkcloud617]

I have a code that logs in to a website as it should but when it goes to click into a drop down menu it errors "Method 'Document' of object 'IWebBrowser 2' failed" and errors on this line

        IE.Document.getElementsByClassName("MenuBar_Menu")(1).Click

Here is the full code:

Sub test()

Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")

    With CreateObject("InternetExplorer.Application")
        Dim chng As Object, chk As Object
        .Visible = True
        .Navigate "https://www.google.com"

        While .Busy Or .ReadyState <> 4: Application.Wait (Now + TimeSerial(0, 0, 1)): Wend

        Set chng = .Document.createEvent("HTMLEvents")
        chng.initEvent "change", True, False

        .Document.getElementById("txtEmail").Value = "XXXX"
        .Document.getElementById("txtPassword").Value = "XXXXX"


        .Document.getElementById("Main_Main_btnSignIn").Click
        
        Application.Wait (Now + TimeValue("0:00:10"))
        
        IE.Document.getElementsByClassName("MenuBar_Menu")(1).Click
        
    End With
    
End Sub

This is a snip of the website code that contains the menu I am trying to click:


I am trying to get VBA to click the last option "All Open Orders in view" but I think I'm getting confused because its a hover drop down menu. When hovering over the box on the website the javascript code changes to "MenuBar_Menu_Item Menu_Item_Hover" from "MenuBar_Menu_Item". I'm not sure how to account for that.

Any help would be greatly appreciated. Thank you.

 

[JEC]

Maybe go for it's ID instead of the Class
Hard to guess without being able to try

 

[John_w]

IE.Document.getElementsByClassName("MenuBar_Menu")(1).Click

IE here doesn't reference a web site because of:

Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")

    With CreateObject("InternetExplorer.Application")

The fix is to change the line to:

        .Document.getElementsByClassName("MenuBar_Menu")(1).Click

and delete the Set IE = .... line.

Also note that (1) references the 2nd element with the "MenuBar_Menu" class name. Use (0) for the 1st element.

 

[Darkcloud617]

Thank you, that did correct the error. I still have the original issue but I will post that in another thread. Thank you so much for the assistance.

 

[Darkcloud617]

Marked as resolved