View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
shart
 
Posts: n/a
Default HTML Forms - Excel


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


--
shart
------------------------------------------------------------------------
shart's Profile: http://www.excelforum.com/member.php...o&userid=29563
View this thread: http://www.excelforum.com/showthread...hreadid=499321