I have the following VBA code to launch an IE application, navigate to a URL,
and submit a form.
The page which pops-up does not have a directly addressable URL, but is
generated
and directly filled-in by java when the form is submitted. What is the VBA
statement needed in the
following code to get a handle to the unnamed spawned page so that objects on
the page can be
referenced ?

Sub Clt_Data_Fetch()
Dim ie As Object

' launch IE and navigate to URL
Set ie = CreateObject("InternetExplorer.Application")
ie.Visible = True
ie.navigate "http://thisistheURL/index.html"

' wait for login page to come up
Do While ie.Busy: DoEvents: Loop
Do Until ie.ReadyState < 1: Loop

' fill in login form and submit
ie.document.all.Item("name").Value = "loginstring"
ie.document.all.Item("passwd").Value = "passwordstring"
ie.document.all.Item("submit").Click

' wait for spawned page to come up
Do While ie.Busy: DoEvents: Loop
Do Until ie.ReadyState < 1: Loop
Application.Wait (Now() + TimeValue("0:00:07"))

' close login page, leaving spawned page visible
ie.Quit

' *********** what is statement needed here to make reference to a 'table'
object with
' ID = "abcTab" in the unnamed spawned page ******************

endSub

--
tmp2100

Message posted via http://www.officekb.com