Microsoft XML - InternetExplorer : how to simulate a click on a form, in order to dump a page in MSAcces

Author

InternetExplorer : how to simulate a click on a form, in order to dump a page in MSAcces

Olivier Delrieu

2004-10-21, 11:14 pm

Dear All,

I want to dump a web page (page2) into a msaccess database. In order to
reach this web page, I have to open a first page (page1) and click on a
button within a form.

I know how to dump a page, but not how to automate the click. Here is my
MSAccess draft module :

dim IE as SHDocVw.InternetExplorer
set IE = new SHDocVw.InternetExplorer

IE.visible = false
IE.navigate ("page1")

' I need something that action this form and redirect IE to page2
' <form name="frmQueryBox" action="page2" method="POST" >
' <...lots of hidden values...>
' <input name="" type="BUTTON" value="Send to">

' then I would store some content in a table
rs("field") = IE.Document.getElementsByTagName("pre").innerText

Any thoughts ?

Thanks,

Olivier

Veign

2004-10-21, 11:14 pm

I know you can execute Javascripts through the Web Browser control. If you
can get this to work pass a JavaScript something like:

"java script:document.frmQueryBox.submit();"

--
Chris Hanscom - Microsoft MVP (VB)
http://www.veign.com
--

"Olivier Delrieu" <pub.removeme@delrieu.org> wrote in message
news:cl9est$gf3$1@titan.btinternet.com...
> Dear All,
>
> I want to dump a web page (page2) into a msaccess database. In order to
> reach this web page, I have to open a first page (page1) and click on a
> button within a form.
>
> I know how to dump a page, but not how to automate the click. Here is my
> MSAccess draft module :
>
> dim IE as SHDocVw.InternetExplorer
> set IE = new SHDocVw.InternetExplorer
>
> IE.visible = false
> IE.navigate ("page1")
>
> ' I need something that action this form and redirect IE to page2
> ' <form name="frmQueryBox" action="page2" method="POST" >
> ' <...lots of hidden values...>
> ' <input name="" type="BUTTON" value="Send to">
>
> ' then I would store some content in a table
> rs("field") = IE.Document.getElementsByTagName("pre").innerText
>
>
> Any thoughts ?
>
> Thanks,
>
> Olivier
>
>

Larry Serflaten

2004-10-21, 11:14 pm

"Olivier Delrieu" <pub.removeme@delrieu.org> wrote
> Dear All,
>
> I want to dump a web page (page2) into a msaccess database. In order to
> reach this web page, I have to open a first page (page1) and click on a
> button within a form.
>
> I know how to dump a page, but not how to automate the click. Here is my
> MSAccess draft module :
>
> dim IE as SHDocVw.InternetExplorer
> set IE = new SHDocVw.InternetExplorer

Use the document object model to find that button object and call its
click method.

LFS