none
internet explorer error for VBA RRS feed

  • Question

  • PLease help!!!

    Sub IE_Autiomation()
        Dim ie As InternetExplorerMedium
        Dim OrgBox As HTMLInputElement
            
            url = ""
            
            Set ie = New InternetExplorerMedium
            ie.Visible = True
            ie.Navigate url
        Do
            If ie.ReadyState = 4 Then
            Exit Do
            Else
            DoEvents
            End If
        Loop
           
           Set doc = ie.Document
           
           ie.Document.getElementById("cxn-additem-btn").Click   '' works fine
           ie.Document.getElementById("cxn-add-btn").Click    ''works fine
           Set OrgBox = ie.Document.getElementById("pin-url") ''Issue is here
            OrgBox.Value = "Hello"

    I am getting error 424 object required.. I am running code using F8(manually). Page loading is taken care.

    Please let me know if you find any solution for this

    Thursday, January 11, 2018 1:59 PM

All replies

  • Hi Nitin Poojari,

    i can see that your issue is related with IE.

    this forum only handles the issues regarding Excel Object Model.

    so for better response and better solution for your issue, i move this thread to VBA Forum.

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us.

    Thank you for your understanding.

    Regards,

    Deepak


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, January 12, 2018 3:20 AM
  • Debugging this is impossible without having the actual URL.  HTML pages can be very complex.  I don't have much luck with Microsoft Internet Controls.  I use SeleniumBasic and use xPaths. The release is dated but IE works fine. 
    Friday, January 12, 2018 1:41 PM