IE Automation - Radio Buttons

[abbaddon223]

Hello experts,

I'm trying to tick "Yes" to a radio button which are side by side on a web page (Yes and No). The HTML is below and the VBA I'm trying to use is:

ie.Document.all.Item("newsletter").Checked = "0"

I've also tried

ie.Document.all.Item("newsletter").Checked = "True"
ie.Document.all.Item("newsletter").value = "True"
ie.Document.all.Item("newsletter").value= "0"

<table class="form"> <tr> <td>Subscribe:</td> <td> <input type="radio" name="newsletter" value="1" /> Yes <input type="radio" name="newsletter" value="0" checked="checked" /> No </td> </tr> </table> </div>Any help would be greatly appreciated please. Thank you.

Phil.

 

[pr2-eugin]

Sorry wrong method.. Give me a minute..

 

[pr2-eugin]

Okay without an ID for the element you will not be able to check a particular Option, as the Radio button needs to be a common name, thus grouping them together in your case "newsletter", if you have something like..

<table class="form">
    <tr> 
        <td>Subscribe:</td> 
        <td> 
            <input type="radio" name="newsletter" value="1" [COLOR=Blue][B]id="yes"[/B][/COLOR] /> Yes 
            <input type="radio" name="newsletter" value="0" [COLOR=Blue][B]id="no"[/B][/COLOR] checked="checked" /> No 
        </td> 
    </tr> 
</table>

Then you can use..

document.getElementById('yes').checked = true;

 

[abbaddon223]

Hi again Pr2-eugin - thanks for the help once more!!

Your last gave me an Object Required error - but I note your point above...

 

[abbaddon223]

Hi,

So will I need to get the web host to change the HTML to get this working as you suggested?

Thank you for the help again!

Phil.

 

[pr2-eugin]

I would say so.. As mentioned, without having a Unique ID you will not be able to refer to the Control, as there is ambiguity.. If you use the Name, both Yes and No options share a common name.. Hope that makes sense..

 

[abbaddon223]

Hi, yes it makes total sense and thank you for the advice! Off to speak to the web developer now!!

Chers,

Phil.