jeudi 26 octobre 2017

VBA checkbox website interaction

I'm currently experiencing a problem with VBA. I'm trying to tick checkbox on an external website. Here is a html snippet that I'm working with:Html code from external website

I have redacted any confidential information from the snippet. Here is my VBA code:

Set elements = objIE.document.getElementsByTagName("input")
    For Each ele In elements
        ele.toString

        If ele.Value = "xxx" Then ele.Click

    Next

So in this code the "elements" variable is an object and the loop variable ele is not being populated at all. I need to compare that the value in the check box contains value xxx. I'm not too experienced in VBA.

Any help would be appreciated

Thanks




Aucun commentaire:

Enregistrer un commentaire