Controling multiple IE pages using VB

[alexanderb]

Hi,

I am trying to automate a process using a VB macro in Outlook. There are two operations it needs to do, submit a form to a web page and capture some of the data in the page it is forwarded to and then open another web page using that data.

I can open an IE window and send it to the appropriate page, using javascript i can fill and submit the form but i do not know how to capture the information in the page that is generated by the server as a result.

Any resources I can look at or code snippets that might be of help?

Thanks, Alex

[RoyK]

The server will do processing and will typically send back a new page with the updated values.

I would use asp.net and set the postback value to true. Much easier.

[adbanginwar]

you can use internet explorer object to do the same in VBA.

Dim IE As InternetExplorer
Set IE = New InternetExplorer
IE.Navigate2 "www.gmail.com"

you can use multiple objects to access multiple pages.
don't forget to set IE to nothing after you finish with it.