Re: Controling a web page - fill in text & submit

"=?Utf-8?B?Y2x1ZWxlc3MgSm9obg==?="
<cluelessJohn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
news:6EB3D4CD-4A34-4502-ABFB-1164DBA980E1@xxxxxxxxxxxxx:

> I am trying to automate a daily download process that manually
> requires me to navigate to a website, select a radio button, fill in
> two text boxes and click a submit button. I can get Access to open
> IExplorer and navigate to the website by using
> Dim ieApp As InternetExplorer
> Set ieApp = New InternetExplorer
> ieApp.Visible = True
> ieApp.Navigate "http://...
>

With a bit of digging around in the form's source code, you should be
able to reconstruct the entire URI of the completed form; then use the
GET or POST method to get the result. You should be able to do this with
a

Set oHttpPost = CreateObject("Microsoft.XMLHTTP")
oHttpPost.Open "GET", c_urlCheckIP, False

or something like that.

Hope it helps


Tim F

.

Loading