How to query a website from a form

[Wim Verhavert]

Hi all,

For gathering certain information in building my database, I'm depending
on the things I found on the web, especially one website (let's call it
www.mywebsite.com). Is there a way to query this site (it has fill in
boxes on the page and a search button) depending on values in my form
and getting the results back in my form? This (general) question is
keeping me out of my sleep for weeks now....

Any tip is appreciated....

Kind regards,

Wim

[TC]

Try the microsoft webbrowser control. Drop one onto your form, then you can
use the .Navigate method to go to that website. Then you can use the methods
& properties of the HTML Document Object Model (which are exposed through
the webbrowser control) to retrieve data from the HTML that the website sent
you.

HTH,
TC
"Wim Verhavert" <wi***********@yahoo.com> wrote in message
news:10***************@seven.kulnet.kuleuven.ac.be ...

Hi all,

For gathering certain information in building my database, I'm depending
on the things I found on the web, especially one website (let's call it
www.mywebsite.com). Is there a way to query this site (it has fill in
boxes on the page and a search button) depending on values in my form
and getting the results back in my form? This (general) question is
keeping me out of my sleep for weeks now....

Any tip is appreciated....

Kind regards,

Wim

[Wim Verhavert]

Is there also a way of automatically filling in the form on that
website? That the program doesn't automatically outputs the data to my
form is not so big a problem.

Thanks anyway!

Regards,
WV

TC wrote:

Try the microsoft webbrowser control. Drop one onto your form, then you can
use the .Navigate method to go to that website. Then you can use the methods
& properties of the HTML Document Object Model (which are exposed through
the webbrowser control) to retrieve data from the HTML that the website sent
you.

HTH,
TC
"Wim Verhavert" <wi***********@yahoo.com> wrote in message
news:10***************@seven.kulnet.kuleuven.ac.be ...

Hi all,

For gathering certain information in building my database, I'm depending
on the things I found on the web, especially one website (let's call it
www.mywebsite.com). Is there a way to query this site (it has fill in
boxes on the page and a search button) depending on values in my form
and getting the results back in my form? This (general) question is
keeping me out of my sleep for weeks now....

Any tip is appreciated....

Kind regards,

Wim

[TC]

Yes, you just use the objects, methods & properties of the Document Object
Model, which is exposed by the webbrowser control. This is similar in
principle (but different in detail) to programming in VBA. For example,
you'd use the Submit method of the relevant named form of the Document
object, to send the form.

Wim, I haven't done this for some time, & the details are no longer clear in
my mind. So you'll have to do some research! Check out the web for
information on "webbrowser control" and "HTML Document Object Model".

HTH,
TC
"Wim Verhavert" <wi***********@yahoo.com> wrote in message
news:10***************@seven.kulnet.kuleuven.ac.be ...

Is there also a way of automatically filling in the form on that
website? That the program doesn't automatically outputs the data to my
form is not so big a problem.

Thanks anyway!

Regards,
WV

TC wrote:

Try the microsoft webbrowser control. Drop one onto your form, then you can use the .Navigate method to go to that website. Then you can use the methods & properties of the HTML Document Object Model (which are exposed through the webbrowser control) to retrieve data from the HTML that the website sent you.

HTH,
TC
"Wim Verhavert" <wi***********@yahoo.com> wrote in message
news:10***************@seven.kulnet.kuleuven.ac.be ...

Hi all,

For gathering certain information in building my database, I'm depending
on the things I found on the web, especially one website (let's call it
www.mywebsite.com). Is there a way to query this site (it has fill in
boxes on the page and a search button) depending on values in my form
and getting the results back in my form? This (general) question is
keeping me out of my sleep for weeks now....

Any tip is appreciated....

Kind regards,

Wim

[Wim Verhavert]

Thanks a lot for all the help!!! You put me in a good thinking path...

TC wrote:

Yes, you just use the objects, methods & properties of the Document Object
Model, which is exposed by the webbrowser control. This is similar in
principle (but different in detail) to programming in VBA. For example,
you'd use the Submit method of the relevant named form of the Document
object, to send the form.

Wim, I haven't done this for some time, & the details are no longer clear in
my mind. So you'll have to do some research! Check out the web for
information on "webbrowser control" and "HTML Document Object Model".

HTH,
TC
"Wim Verhavert" <wi***********@yahoo.com> wrote in message
news:10***************@seven.kulnet.kuleuven.ac.be ...

Is there also a way of automatically filling in the form on that
website? That the program doesn't automatically outputs the data to my
form is not so big a problem.

Thanks anyway!

Regards,
WV

TC wrote:

Try the microsoft webbrowser control. Drop one onto your form, then you
can
use the .Navigate method to go to that website. Then you can use the
methods
& properties of the HTML Document Object Model (which are exposed
through
the webbrowser control) to retrieve data from the HTML that the website
sent
you.

HTH,
TC
"Wim Verhavert" <wi***********@yahoo.com> wrote in message
news:10***************@seven.kulnet.kuleuven.ac .be...
Hi all,

For gathering certain information in building my database, I'm depending
on the things I found on the web, especially one website (let's call it
www.mywebsite.com). Is there a way to query this site (it has fill in
boxes on the page and a search button) depending on values in my form
and getting the results back in my form? This (general) question is
keeping me out of my sleep for weeks now....

Any tip is appreciated....

Kind regards,

Wim