Driving a website using VFP

Is there any way to programmatically drive a website using VFP? I want to log onto the site (username and password from FVP data) and then take specific actions within that site using VFP controlled logic and data. For example, I want to be able to initiate a file download from a site and store the data without any user intervention. If someone knows how to do this and has successfully done it, please let me know what you did.

Thanks in advance

swdev2
Wed Feb 04 23:03:13 CST 2004

Heya Softmica -
way back when -
West Wind Web Connection on IIS - then on client workstation -
was VFP program with an encapsulated browser.

so vfp on client side would drive the browser client, log in to vfp driven
web site,
check for any updates - and if updates to 'get' ?
the webserver would select the records into table, zip it up, and initiate a
file transfer
with http to the vfp client.
vfp client would then extract the zip file, and read in the table to its
data store.

design was straightforward - coding was not so tedious.
Should be repeatable .

But - I think you just want to drive the website (client browser) via vfp.
The answer is YES !
you can encapsulate any browser you want, or use the webbrowser control in
vfp 8.
is basic concept of screen scraping in IE with vfp.

hth - mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
Mondo Cool TeleCom -> http://www.efgroup.net/efgcog.html
Mondo Cool WebHosting -> http://www.efgroup.net/efglunar.html
Mondo Cool Satellites -> http://www.efgroup.net/sat
mySql / VFP / MS-SQL

"Softmica" <anonymous@discussions.microsoft.com> wrote in message
news:013A580C-75BD-4C18-BDC9-2FD9A8F8227E@microsoft.com...
> Is there any way to programmatically drive a website using VFP? I want to
log onto the site (username and password from FVP data) and then take
specific actions within that site using VFP controlled logic and data. For
example, I want to be able to initiate a file download from a site and store
the data without any user intervention. If someone knows how to do this and
has successfully done it, please let me know what you did.
>
> Thanks in advance

Neil
Thu Feb 05 15:23:27 CST 2004

Hi,

If you just need to upload/download files, you can use FTP transfer. There's
a VFP class available on www.universalthread.com which works fine (download
ID 9442). Not sure if you need browser capability from your "without any
user intervention" line. What are you trying to do?

If it's an entire VFP driven website you want, then visit West Wind
(www.west-wind.com) like Bill suggested, although I think there are other
possibilities. FoxWeb springs to mind (www.foxweb.com).

Regards,
Neil

"Softmica" <anonymous@discussions.microsoft.com> wrote in message
news:013A580C-75BD-4C18-BDC9-2FD9A8F8227E@microsoft.com...
> Is there any way to programmatically drive a website using VFP? I want to
log onto the site (username and password from FVP data) and then take
specific actions within that site using VFP controlled logic and data. For
example, I want to be able to initiate a file download from a site and store
the data without any user intervention. If someone knows how to do this and
has successfully done it, please let me know what you did.
>
> Thanks in advance

anonymous
Thu Feb 05 21:31:06 CST 2004

What I am trying to do is log onto a website and then navigate to the appropriate page and then click a link which will initiate a file download.... although I want to be able to specify the download location without user intervention.

In another section of the program, I want to log onto another website, select another page which will again require a log on, and then fill in certain fields automatically (again... no user intervention), submit the website and then copy the confirmation page that is generated to a memo field in a VFP application.

There can be no user intervention required as these activities are time-sensitive and need to be controlled automatically by the VFP application.

I've tried westwind stuff and it didn't work for what I need to do. I am amazed that nobody is routinely doing this.

Anyway, if you have some specific ideas, let me know. I've tried to use the InternetExplorer object but I cannot identify the logon page when it comes up.

Hope you or someone else has some ideas.

Jim

swdev2
Fri Feb 06 08:05:35 CST 2004

Hullo Softmica .

Yes - what you've described is not only do-able - but has be working for
many for past 4 years.
Login forms/objects are strange sometimes - so If I were you - I would find
out what gen'd it [vbscript, asp, java, javascript, etc] then get that
object in vfp, and send the things you need to it .

There are other approaches to this - if you study them, the light bulbs
might come on. Use search term of 'html form scraping', 'web form
scraping', 'web screen scraping' . I don't rely on the 'InternetExplorer '
object at all - it has some flaws that I hit the wall with.

foxite, UT, FPA - all have examples of how to do in vfp.
mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
Mondo Cool TeleCom -> http://www.efgroup.net/efgcog.html
Mondo Cool WebHosting -> http://www.efgroup.net/efglunar.html
Mondo Cool Satellites -> http://www.efgroup.net/sat
mySql / VFP / MS-SQL

"softmica" <anonymous@discussions.microsoft.com> wrote in message
news:A185ED1E-F9DF-4CC9-B80C-00A552C1C265@microsoft.com...
> What I am trying to do is log onto a website and then navigate to the
appropriate page and then click a link which will initiate a file
download.... although I want to be able to specify the download location
without user intervention.
>
> In another section of the program, I want to log onto another website,
select another page which will again require a log on, and then fill in
certain fields automatically (again... no user intervention), submit the
website and then copy the confirmation page that is generated to a memo
field in a VFP application.
>
> There can be no user intervention required as these activities are
time-sensitive and need to be controlled automatically by the VFP
application.
>
> I've tried westwind stuff and it didn't work for what I need to do. I am
amazed that nobody is routinely doing this.
>
> Anyway, if you have some specific ideas, let me know. I've tried to use
the InternetExplorer object but I cannot identify the logon page when it
comes up.
>
> Hope you or someone else has some ideas.
>
> Jim

David
Fri Feb 06 09:29:05 CST 2004

Jim,

It's pretty easy to automate a form in IE:

oIE = createobject( "internetexplorer.application" )
oIE.Visible = .t.
oIE.Navigate( "www.google.com" )
do while oie.Busy()
doevents
enddo
loDoc = oIE.Document && get the Document object
loForm = loDoc.forms(0) && get the first form object
loForm.Item(3).Value = "foxpro" && this is the field for the search string
loform.Submit() && submit the form

you can use code like to find the items of a form:

* explore the form items

for i = 0 to loForm.Length-1
? i, loForm.Item(i).Name, loForm.Item(i).Value
endfor

You can also access the items by their names:

loItem = loForm.item( "q" )
loItem.value = "this is so cool"

If you have VFP8 or VFP7 this stuff becomes really trivial because of
Intellisense. You can just kind of explore things from the command window.
You can also lookup IE DocumentObjectModel (DOM) on MSDN to help direct your
explorations.


--
df - Microsoft MVP FoxPro http://www.geocities.com/df_foxpro

"softmica" <anonymous@discussions.microsoft.com> wrote in message
news:A185ED1E-F9DF-4CC9-B80C-00A552C1C265@microsoft.com...
> What I am trying to do is log onto a website and then navigate to the
appropriate page and then click a link which will initiate a file
download.... although I want to be able to specify the download location
without user intervention.
>
> In another section of the program, I want to log onto another website,
select another page which will again require a log on, and then fill in
certain fields automatically (again... no user intervention), submit the
website and then copy the confirmation page that is generated to a memo
field in a VFP application.
>
> There can be no user intervention required as these activities are
time-sensitive and need to be controlled automatically by the VFP
application.
>
> I've tried westwind stuff and it didn't work for what I need to do. I am
amazed that nobody is routinely doing this.
>
> Anyway, if you have some specific ideas, let me know. I've tried to use
the InternetExplorer object but I cannot identify the logon page when it
comes up.
>
> Hope you or someone else has some ideas.
>
> Jim

Neil
Fri Feb 06 12:28:07 CST 2004

Further to the IE automation stuff above, the URLDownLoadToFile() API
function might be useful. It's described at:

http://www.news2news.com/vfp/?group=-1&function=268

Regards,
Neil

"softmica" <anonymous@discussions.microsoft.com> wrote in message
news:A185ED1E-F9DF-4CC9-B80C-00A552C1C265@microsoft.com...
> What I am trying to do is log onto a website and then navigate to the
appropriate page and then click a link which will initiate a file
download.... although I want to be able to specify the download location
without user intervention.
>
> In another section of the program, I want to log onto another website,
select another page which will again require a log on, and then fill in
certain fields automatically (again... no user intervention), submit the
website and then copy the confirmation page that is generated to a memo
field in a VFP application.
>
> There can be no user intervention required as these activities are
time-sensitive and need to be controlled automatically by the VFP
application.
>
> I've tried westwind stuff and it didn't work for what I need to do. I am
amazed that nobody is routinely doing this.
>
> Anyway, if you have some specific ideas, let me know. I've tried to use
the InternetExplorer object but I cannot identify the logon page when it
comes up.
>
> Hope you or someone else has some ideas.
>
> Jim

Neil
Fri Feb 06 17:47:38 CST 2004

Further again, you can usually insert the username and password into the
URL, if you're using basic authentication, e.g.

cSource = "http://user:pass@www.somewhere.com/myfile.xyz"

You might be able to bypass the form based authentication part using
URLDownloadToFile() with this. Maybe not, but still food for thought.

Neil

"Neil Waterworth" <nospam-or-nwaterworth@lineone.net> wrote in message
news:OYZ257N7DHA.3360@tk2msftngp13.phx.gbl...
> Further to the IE automation stuff above, the URLDownLoadToFile() API
> function might be useful. It's described at:
>
> http://www.news2news.com/vfp/?group=-1&function=268
>
> Regards,
> Neil
>
> "softmica" <anonymous@discussions.microsoft.com> wrote in message
> news:A185ED1E-F9DF-4CC9-B80C-00A552C1C265@microsoft.com...
> > What I am trying to do is log onto a website and then navigate to the
> appropriate page and then click a link which will initiate a file
> download.... although I want to be able to specify the download location
> without user intervention.
> >
> > In another section of the program, I want to log onto another website,
> select another page which will again require a log on, and then fill in
> certain fields automatically (again... no user intervention), submit the
> website and then copy the confirmation page that is generated to a memo
> field in a VFP application.
> >
> > There can be no user intervention required as these activities are
> time-sensitive and need to be controlled automatically by the VFP
> application.
> >
> > I've tried westwind stuff and it didn't work for what I need to do. I
am
> amazed that nobody is routinely doing this.
> >
> > Anyway, if you have some specific ideas, let me know. I've tried to use
> the InternetExplorer object but I cannot identify the logon page when it
> comes up.
> >
> > Hope you or someone else has some ideas.
> >
> > Jim
>
>

Karen
Sun Feb 08 10:01:16 CST 2004

Be aware that there is an IE security patch (Q832894) that breaks your
cSource.

"Neil Waterworth" <nospam-or-nwaterworth@lineone.net> wrote in message
news:eyayauQ7DHA.1852@TK2MSFTNGP10.phx.gbl...
> Further again, you can usually insert the username and password into the
> URL, if you're using basic authentication, e.g.
>
> cSource = "http://user:pass@www.somewhere.com/myfile.xyz"
>
> You might be able to bypass the form based authentication part using
> URLDownloadToFile() with this. Maybe not, but still food for thought.
>
> Neil
>
> "Neil Waterworth" <nospam-or-nwaterworth@lineone.net> wrote in message
> news:OYZ257N7DHA.3360@tk2msftngp13.phx.gbl...
> > Further to the IE automation stuff above, the URLDownLoadToFile() API
> > function might be useful. It's described at:
> >
> > http://www.news2news.com/vfp/?group=-1&function=268
> >
> > Regards,
> > Neil
> >
> > "softmica" <anonymous@discussions.microsoft.com> wrote in message
> > news:A185ED1E-F9DF-4CC9-B80C-00A552C1C265@microsoft.com...
> > > What I am trying to do is log onto a website and then navigate to the
> > appropriate page and then click a link which will initiate a file
> > download.... although I want to be able to specify the download
location
> > without user intervention.
> > >
> > > In another section of the program, I want to log onto another website,
> > select another page which will again require a log on, and then fill in
> > certain fields automatically (again... no user intervention), submit the
> > website and then copy the confirmation page that is generated to a memo
> > field in a VFP application.
> > >
> > > There can be no user intervention required as these activities are
> > time-sensitive and need to be controlled automatically by the VFP
> > application.
> > >
> > > I've tried westwind stuff and it didn't work for what I need to do. I
> am
> > amazed that nobody is routinely doing this.
> > >
> > > Anyway, if you have some specific ideas, let me know. I've tried to
use
> > the InternetExplorer object but I cannot identify the logon page when it
> > comes up.
> > >
> > > Hope you or someone else has some ideas.
> > >
> > > Jim
> >
> >
>
>

Neil
Sun Feb 08 15:35:27 CST 2004

Hi Karen,

Thanks for pointing that out. Damn those "specially-crafted links". Wonder
if Mozilla and Opera have this problem.

"Karen" <karenqsb@hotmail.com> wrote in message
news:OdvFEzl7DHA.2432@TK2MSFTNGP10.phx.gbl...
> Be aware that there is an IE security patch (Q832894) that breaks your
> cSource.
>
> "Neil Waterworth" <nospam-or-nwaterworth@lineone.net> wrote in message
> news:eyayauQ7DHA.1852@TK2MSFTNGP10.phx.gbl...
> > Further again, you can usually insert the username and password into the
> > URL, if you're using basic authentication, e.g.
> >
> > cSource = "http://user:pass@www.somewhere.com/myfile.xyz"
> >
> > You might be able to bypass the form based authentication part using
> > URLDownloadToFile() with this. Maybe not, but still food for thought.
> >
> > Neil
> >
> > "Neil Waterworth" <nospam-or-nwaterworth@lineone.net> wrote in message
> > news:OYZ257N7DHA.3360@tk2msftngp13.phx.gbl...
> > > Further to the IE automation stuff above, the URLDownLoadToFile() API
> > > function might be useful. It's described at:
> > >
> > > http://www.news2news.com/vfp/?group=-1&function=268
> > >
> > > Regards,
> > > Neil
> > >
> > > "softmica" <anonymous@discussions.microsoft.com> wrote in message
> > > news:A185ED1E-F9DF-4CC9-B80C-00A552C1C265@microsoft.com...
> > > > What I am trying to do is log onto a website and then navigate to
the
> > > appropriate page and then click a link which will initiate a file
> > > download.... although I want to be able to specify the download
> location
> > > without user intervention.
> > > >
> > > > In another section of the program, I want to log onto another
website,
> > > select another page which will again require a log on, and then fill
in
> > > certain fields automatically (again... no user intervention), submit
the
> > > website and then copy the confirmation page that is generated to a
memo
> > > field in a VFP application.
> > > >
> > > > There can be no user intervention required as these activities are
> > > time-sensitive and need to be controlled automatically by the VFP
> > > application.
> > > >
> > > > I've tried westwind stuff and it didn't work for what I need to do.
I
> > am
> > > amazed that nobody is routinely doing this.
> > > >
> > > > Anyway, if you have some specific ideas, let me know. I've tried to
> use
> > > the InternetExplorer object but I cannot identify the logon page when
it
> > > comes up.
> > > >
> > > > Hope you or someone else has some ideas.
> > > >
> > > > Jim
> > >
> > >
> >
> >
>
>

Neil
Mon Feb 09 14:12:16 CST 2004

Hi Jim,

cURL2 contains no forms, so IoForm will get a .NULL. value. You can't
manipulate a non-existent form.

cURL1 uses basic authentication, which is different from HTML form based
authentication. The only way I know around it is to use:

#DEFINE cURL1
"http://username:password@www.nwaalpa.org/pilots/scheds/index.html"

As Karen pointed out in her reply to my post below, MS screwed this
technique about a week ago with their latest IE security patch, so it
probably isn't a long term solution. Not sure if there's a workaround.

Regards,
Neil

"softmica" <anonymous@discussions.microsoft.com> wrote in message
news:CF2B8031-D4EB-483B-A768-888FD9BDC9E3@microsoft.com...
> I tried this code:
> #DEFINE cURL1 "www.nwaalpa.org/pilots/scheds/index.html"
> #DEFINE cURL2 "www.nwaalpa.org"
> oIE = CREATEOBJECT("internetexplorer.application")
> oIE.Visible = .T.
> oIE.Navigate(cURL2)
> DO WHILE oIE.Busy()
> doevents
> ENDDO
> IoDoc = oIE.Document
> IoForm = IoDoc.Forms(0)
>
> FOR i = 0 TO IoForm.Length-1
> ?i,ioForm.Item(i).Name, IoForm.Item(i).Value
> Endfor
> *******
> Got the error "IoForm is not an object" What's happening here and is
there any way around it? Still don't see how I will separately identify the
authentication form that appears first if I select cURL1 which is the URL I
really want to start with.
>
> ----- David Frankenbach wrote: -----
>
> Jim,
>
> It's pretty easy to automate a form in IE:
>
> oIE = createobject( "internetexplorer.application" )
> oIE.Visible = .t.
> oIE.Navigate( "www.google.com" )
> do while oie.Busy()
> doevents
> enddo
> loDoc = oIE.Document && get the Document object
> loForm = loDoc.forms(0) && get the first form object
> loForm.Item(3).Value = "foxpro" && this is the field for the search
string
> loform.Submit() && submit the form
>
> you can use code like to find the items of a form:
>
> * explore the form items
>
> for i = 0 to loForm.Length-1
> ? i, loForm.Item(i).Name, loForm.Item(i).Value
> endfor
>
> You can also access the items by their names:
>
> loItem = loForm.item( "q" )
> loItem.value = "this is so cool"
>
> If you have VFP8 or VFP7 this stuff becomes really trivial because of
> Intellisense. You can just kind of explore things from the command
window.
> You can also lookup IE DocumentObjectModel (DOM) on MSDN to help
direct your
> explorations.
>
>
> --
> df - Microsoft MVP FoxPro http://www.geocities.com/df_foxpro
>
> "softmica" <anonymous@discussions.microsoft.com> wrote in message
> news:A185ED1E-F9DF-4CC9-B80C-00A552C1C265@microsoft.com...
> > What I am trying to do is log onto a website and then navigate to
the
> appropriate page and then click a link which will initiate a file
> download.... although I want to be able to specify the download
location
> without user intervention.
> >> In another section of the program, I want to log onto another
website,
> select another page which will again require a log on, and then fill
in
> certain fields automatically (again... no user intervention), submit
the
> website and then copy the confirmation page that is generated to a
memo
> field in a VFP application.
> >> There can be no user intervention required as these activities are
> time-sensitive and need to be controlled automatically by the VFP
> application.
> >> I've tried westwind stuff and it didn't work for what I need to
do. I am
> amazed that nobody is routinely doing this.
> >> Anyway, if you have some specific ideas, let me know. I've tried
to use
> the InternetExplorer object but I cannot identify the logon page when
it
> comes up.
> >> Hope you or someone else has some ideas.
> >> Jim
>
>
>

Neil
Mon Feb 09 15:02:25 CST 2004

Hi Karen,

> Be aware that there is an IE security patch (Q832894) that breaks your
> cSource.
>

Thought I'd try it and cSource doesn't break here using URLDownLoadToFile.
It does break using IE. If you try it with IE, you get a "syntax error"
page, so I'm guessing MS just stopped IE from passing anything with a ":",
or an "@" or whatever in a certain part of the URL, and the API function
remains the same as before. At least I hope so.

Regards,
Neil

> "Neil Waterworth" <nospam-or-nwaterworth@lineone.net> wrote in message
> news:eyayauQ7DHA.1852@TK2MSFTNGP10.phx.gbl...
> > Further again, you can usually insert the username and password into the
> > URL, if you're using basic authentication, e.g.
> >
> > cSource = "http://user:pass@www.somewhere.com/myfile.xyz"
> >
> > You might be able to bypass the form based authentication part using
> > URLDownloadToFile() with this. Maybe not, but still food for thought.
> >
> > Neil
> >
> > "Neil Waterworth" <nospam-or-nwaterworth@lineone.net> wrote in message
> > news:OYZ257N7DHA.3360@tk2msftngp13.phx.gbl...
> > > Further to the IE automation stuff above, the URLDownLoadToFile() API
> > > function might be useful. It's described at:
> > >
> > > http://www.news2news.com/vfp/?group=-1&function=268
> > >
> > > Regards,
> > > Neil
> > >
> > > "softmica" <anonymous@discussions.microsoft.com> wrote in message
> > > news:A185ED1E-F9DF-4CC9-B80C-00A552C1C265@microsoft.com...
> > > > What I am trying to do is log onto a website and then navigate to
the
> > > appropriate page and then click a link which will initiate a file
> > > download.... although I want to be able to specify the download
> location
> > > without user intervention.
> > > >
> > > > In another section of the program, I want to log onto another
website,
> > > select another page which will again require a log on, and then fill
in
> > > certain fields automatically (again... no user intervention), submit
the
> > > website and then copy the confirmation page that is generated to a
memo
> > > field in a VFP application.
> > > >
> > > > There can be no user intervention required as these activities are
> > > time-sensitive and need to be controlled automatically by the VFP
> > > application.
> > > >
> > > > I've tried westwind stuff and it didn't work for what I need to do.
I
> > am
> > > amazed that nobody is routinely doing this.
> > > >
> > > > Anyway, if you have some specific ideas, let me know. I've tried to
> use
> > > the InternetExplorer object but I cannot identify the logon page when
it
> > > comes up.
> > > >
> > > > Hope you or someone else has some ideas.
> > > >
> > > > Jim
> > >
> > >
> >
> >
>
>

anonymous
Mon Feb 09 16:51:05 CST 2004

So how do I get to the correct page (info changes monthly) if I cannot somehow parse the form??
Is anyone doing this sort of thing, and if so.... specifically how are you doing it???

David
Mon Feb 09 21:45:35 CST 2004

Jim,

You should first navigate to this page I assume,
http://www.nwaalpa.org/pilot_access.html you are talking about the link from
the bottom of the first page labels as "Pilots"

Once this page comes up I see a form that you can pre-fill and then submit
to go onto the secure site.

--
df - Microsoft MVP FoxPro http://www.geocities.com/df_foxpro

"softmica" <anonymous@discussions.microsoft.com> wrote in message
news:CF2B8031-D4EB-483B-A768-888FD9BDC9E3@microsoft.com...
> I tried this code:
> #DEFINE cURL1 "www.nwaalpa.org/pilots/scheds/index.html"
> #DEFINE cURL2 "www.nwaalpa.org"
> oIE = CREATEOBJECT("internetexplorer.application")
> oIE.Visible = .T.
> oIE.Navigate(cURL2)
> DO WHILE oIE.Busy()
> doevents
> ENDDO
> IoDoc = oIE.Document
> IoForm = IoDoc.Forms(0)
>
> FOR i = 0 TO IoForm.Length-1
> ?i,ioForm.Item(i).Name, IoForm.Item(i).Value
> Endfor
> *******
> Got the error "IoForm is not an object" What's happening here and is
there any way around it? Still don't see how I will separately identify the
authentication form that appears first if I select cURL1 which is the URL I
really want to start with.
>

Karen
Tue Feb 10 08:08:05 CST 2004

Thanks Neil. It always pays to test these things in specific circumstances.


"Neil Waterworth" <nospam-or-nwaterworth@lineone.net> wrote in message
news:OI%23KGA17DHA.696@tk2msftngp13.phx.gbl...
> Hi Karen,
>
> > Be aware that there is an IE security patch (Q832894) that breaks your
> > cSource.
> >
>
> Thought I'd try it and cSource doesn't break here using URLDownLoadToFile.
> It does break using IE. If you try it with IE, you get a "syntax error"
> page, so I'm guessing MS just stopped IE from passing anything with a ":",
> or an "@" or whatever in a certain part of the URL, and the API function
> remains the same as before. At least I hope so.
>
> Regards,
> Neil
>
> > "Neil Waterworth" <nospam-or-nwaterworth@lineone.net> wrote in message
> > news:eyayauQ7DHA.1852@TK2MSFTNGP10.phx.gbl...
> > > Further again, you can usually insert the username and password into
the
> > > URL, if you're using basic authentication, e.g.
> > >
> > > cSource = "http://user:pass@www.somewhere.com/myfile.xyz"
> > >
> > > You might be able to bypass the form based authentication part using
> > > URLDownloadToFile() with this. Maybe not, but still food for thought.
> > >
> > > Neil
> > >
> > > "Neil Waterworth" <nospam-or-nwaterworth@lineone.net> wrote in message
> > > news:OYZ257N7DHA.3360@tk2msftngp13.phx.gbl...
> > > > Further to the IE automation stuff above, the URLDownLoadToFile()
API
> > > > function might be useful. It's described at:
> > > >
> > > > http://www.news2news.com/vfp/?group=-1&function=268
> > > >
> > > > Regards,
> > > > Neil
> > > >
> > > > "softmica" <anonymous@discussions.microsoft.com> wrote in message
> > > > news:A185ED1E-F9DF-4CC9-B80C-00A552C1C265@microsoft.com...
> > > > > What I am trying to do is log onto a website and then navigate to
> the
> > > > appropriate page and then click a link which will initiate a file
> > > > download.... although I want to be able to specify the download
> > location
> > > > without user intervention.
> > > > >
> > > > > In another section of the program, I want to log onto another
> website,
> > > > select another page which will again require a log on, and then fill
> in
> > > > certain fields automatically (again... no user intervention), submit
> the
> > > > website and then copy the confirmation page that is generated to a
> memo
> > > > field in a VFP application.
> > > > >
> > > > > There can be no user intervention required as these activities are
> > > > time-sensitive and need to be controlled automatically by the VFP
> > > > application.
> > > > >
> > > > > I've tried westwind stuff and it didn't work for what I need to
do.
> I
> > > am
> > > > amazed that nobody is routinely doing this.
> > > > >
> > > > > Anyway, if you have some specific ideas, let me know. I've tried
to
> > use
> > > > the InternetExplorer object but I cannot identify the logon page
when
> it
> > > > comes up.
> > > > >
> > > > > Hope you or someone else has some ideas.
> > > > >
> > > > > Jim
> > > >
> > > >
> > >
> > >
> >
> >
>
>