O
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
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