Hi,

I am writing some code to fill in a form on a web page which I don't have control of. I'm using something along the lines of:

Dim IE as InternetExplorer

Set IE = new InternetExplorer

With IE
  .Navigate "blah"
  .Document.formname.elementname.value = "blah"
etc

Trouble is the form loads into a new window after the navigate line so the questions are...

1. how do I set an internetexplorer object to reference this new window so that I can start entering on the form?

2. once i've done this how do I "click" the submit button?

Any help much appreciated
Cheers,
J

you can trap the new window creation and provide your own IE object, then you can control the new window using the same code you already posted. Here's a simple example:
1. Declare 2 form level IE objects, be sure to declare them WithEvents (I'll assume they're called g_ie and g_ie2...)
2. Create the first IE object (g_ie) and call its Navigate function
using the code you posted already
3. because you declared g_ie WithEvents, you'll have a placeholder for a procedure named g_ie_NewWindow2. The default parameter ppDisp is the object that will be used to create the new window, so this is where g_ie2 comes in - add code here to supply your own IE object (g_ie2) instead of the default ppDisp. Like this:
Private Sub g_ie_NewWindow2(ppDisp As Object, Cancel As Boolean)

    Set g_ie2 = New InternetExplorer
    Set ppDisp = g_ie2
    Cancel = False

End Sub
4. now the new window can be referenced using your variable g_ie2, so you can just fill in the form fields using g_ie2.Document and call g_ie2.Document.formname.submitname.submit to submit the form

hth
Phil

Correction, you don't need the submitname to submit the form, so
g_ie2.Document.formname.submitname.submit
should just be
g_ie2.Document.formname.submit