Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HTML Forms - Excel
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: http://www.excelforum.com/member.php...o&userid=29563 View this thread: http://www.excelforum.com/showthread...hreadid=499321 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Sorting Columns on HTML file created in Excel | Excel Discussion (Misc queries) | |||
Convert excel table to HTML | Excel Discussion (Misc queries) | |||
Using Excel to analyze HTML | Excel Discussion (Misc queries) | |||
HTML to Excel | Excel Discussion (Misc queries) |