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

[Olivier Delrieu]

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]

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

"javascript:document.frmQueryBox.submit();"

 

[Larry Serflaten]

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