HTML Forms - Excel

S

shart

We have successfully been able to navigate IE (using VBA) to the page we
need to import, we need to be able to use VBA to submit two radio button
values to the form before submitting the form.

Problem - Radio button names change everytime the page is loaded.

Question - How do we tell IE via VBA to select the 1st radio button in
set one and the 3rd in set two, then submit the form?

Thank You.
Simon.


The Form (note: fF89, F410, F411 and F412 change everythime the page is
loaded.)
<form method=post onsubmit="" action=submit.cgi name=fF89>
<input type=hidden name=FORM_TOP value=FORM_TOP>
<input type=submit name=F410 value="Show">

<input type=radio name=F411 value="0" checked> By Count of Items Sold
<input type=radio name=F411 value="1"> By Count of Orders
<input type=radio name=F411 value="2"> By Revenue

<input type=radio name=F412 value="0"> Last 10 Days
<input type=radio name=F412 value="1"> Last 30 Days
<input type=radio name=F412 value="2"> Last 60 Days
<input type=radio name=F412 value="3"> Last 90 Days
<input type=radio name=F412 value="4"> Last 120 Days
<input type=radio name=F412 value="5"> Last 180 Days
<input type=radio name=F412 value="6" checked> Last 365 Days
<input type=radio name=F412 value="7"> August 2005
<input type=radio name=F412 value="8"> September 2005
<input type=radio name=F412 value="9"> October 2005
<input type=radio name=F412 value="10"> November 2005
<input type=radio name=F412 value="11"> December 2005

<input type=hidden name=FORM_BOT value=FORM_BOT>
</form>
 
S

shart

Would we able to use:

HTMLInputElement.click(4)

or something similar to select the 4th radio button, then
ie.submit to submit the form?

I tried the above, didn't work. Any suggestions?

thank you.
Simon.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top