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
Bookmarks