View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
safflenow safflenow is offline
external usenet poster
 
Posts: 4
Default Excel Import by Webquery

I am currently running a web query that requires the macro to make a few
adjustments before submitting a form on a web page. All works well until I
try to change a radio button.

With IE
.Visible = True
.Navigate "http://www.freddiemac.com/mbs/cgi-bin/newdeal.pl?"

' Loop until the page is fully loaded
Do Until Not .Busy
DoEvents
Loop
Application.Wait (Now() + TimeValue("0:00:02"))

' Make the desired selections on the web page and click the submit Button
Set ipf = IE.document.all.Item("RemicNum")
ipf.Value = i
Set ipf = IE.document.all.Item("SET")
ipf.Value = "CHECKED"

IE.document.Forms(0).submit

Sadly, the code does not work. Does anyone know how I can change the button
via the web query?

Regards