S
safflenow
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
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