Hi,

Just wondered if you know the answer to my question.

I want to run a search in IE using VBA, however the search I am conducting comes in more than one part. (i.e. the first search returns another webpage that requires a further search entry to be entered) I can perform the first search but then I do not know how to focus on the new displayed webpage to conduct the next search.

Any ideas?

Here is my code so far

Sub using_IE6_From_Excel2()
Dim IeApp As Object
Dim web_page_name As String
'
Set IeApp = CreateObject("internetexplorer.application")
'
IeApp.Visible = True
'
web_page_name = "http://www.voa.gov.uk/cti/InitS.asp?lcn=0"
IeApp.Navigate2 web_page_name
'
Do
Loop Until IeApp.ReadyState = READYSTATE_COMPLETE
'
IeApp.Document.forms(1)("txtPostCode").Value = "le1"
IeApp.Document.forms(1).submit
'
Do
Loop Until IeApp.ReadyState = READYSTATE_COMPLETE
'
' NOW HOW DO I SEARCH THE NEWLY DISPLAYED WEBPAGE ?
End Sub