software

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.)
lt;form method=post onsubmit=quot;quot; action=submit.cgi name=fF89gt;
lt;input type=hidden name=FORM_TOP value=FORM_TOPgt;
lt;input type=submit name=F410 value=quot;Showquot;gt;

lt;input type=radio name=F411 value=quot;0quot; checkedgt;By Count of Items Sold
lt;input type=radio name=F411 value=quot;1quot;gt;By Count of Orders
lt;input type=radio name=F411 value=quot;2quot;gt;By Revenue

lt;input type=radio name=F412 value=quot;0quot;gt;Last 10 Days
lt;input type=radio name=F412 value=quot;1quot;gt;Last 30 Days
lt;input type=radio name=F412 value=quot;2quot;gt;Last 60 Days
lt;input type=radio name=F412 value=quot;3quot;gt;Last 90 Days
lt;input type=radio name=F412 value=quot;4quot;gt;Last 120 Days
lt;input type=radio name=F412 value=quot;5quot;gt;Last 180 Days
lt;input type=radio name=F412 value=quot;6quot; checkedgt;Last 365 Days
lt;input type=radio name=F412 value=quot;7quot;gt;August 2005
lt;input type=radio name=F412 value=quot;8quot;gt;September 2005
lt;input type=radio name=F412 value=quot;9quot;gt;October 2005
lt;input type=radio name=F412 value=quot;10quot;gt;November 2005
lt;input type=radio name=F412 value=quot;11quot;gt;December 2005

lt;input type=hidden name=FORM_BOT value=FORM_BOTgt;
lt;/formgt;--
shart
------------------------------------------------------------------------
shart's Profile: www.excelforum.com/member.php...oamp;userid=29563
View this thread: www.excelforum.com/showthread...hreadid=499321
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.--
shart
------------------------------------------------------------------------
shart's Profile: www.excelforum.com/member.php...oamp;userid=29563
View this thread: www.excelforum.com/showthread...hreadid=499321