Flexology
asked on
Internet Explorer VB Control - Accessing Frames
Hello,
We've been given a website to access to retreive our POD but we have to login each time and then enter in the reference. We have an access database that ahs the reference so i'm looking for a way to automate the login and search. I've looked round and have written the following code:
Private Sub GetPOD_Click()
Dim IE As InternetExplorer
Set IE = CreateObject("Internetexpl orer.appli cation")
IE.Visible = True
IE.Navigate "http://www.xxxxxxxxx"
'This will wait complete page download...
Do While IE.Busy
DoEvents
Loop
IE.Document.frames(1).Docu ment.form1 .T1.Value = "xxx"
IE.Document.frames(1).form 1.T2.Value = "xxx"
IE.Document.frames(1).form 1.T3.Value = "xxx"
IE.Document.frames(1).form 1.submit
End Sub
The webpage that has the login script is framed and we want to access the frame called main. I didn't develop the website so I can't change anything.
The basic question I'm asking is "How do I enter in data into a form and submitted located in a frame"
Please help
Thanks
Andrew
We've been given a website to access to retreive our POD but we have to login each time and then enter in the reference. We have an access database that ahs the reference so i'm looking for a way to automate the login and search. I've looked round and have written the following code:
Private Sub GetPOD_Click()
Dim IE As InternetExplorer
Set IE = CreateObject("Internetexpl
IE.Visible = True
IE.Navigate "http://www.xxxxxxxxx"
'This will wait complete page download...
Do While IE.Busy
DoEvents
Loop
IE.Document.frames(1).Docu
IE.Document.frames(1).form
IE.Document.frames(1).form
IE.Document.frames(1).form
End Sub
The webpage that has the login script is framed and we want to access the frame called main. I didn't develop the website so I can't change anything.
The basic question I'm asking is "How do I enter in data into a form and submitted located in a frame"
Please help
Thanks
Andrew
Provide a link to the site in question or post the relevant HTML.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you. Works like a charm. Some modification required as suggsted.
Thanks......
Thanks......