Hi,

I am kind of new to VBA and automation.

Actually I am trying to automate the below process,

Open a new browser, goto the URL
Supply credentials and login
In the next page click on a explorer icon present in that page

I tried to do some coding and i have been successful only till opening the page and after seems like impossible to me...

Below is the code of what i have done so far,


[vba]
Public Sub ie()
Dim ie As Object
Dim lform As Object

Set ie = CreateObject("internetexplorer.Application")
ie.navigate2 "******"
Do Until ie.readystate = 4
DoEvents
Loop
ie.Visible = True ' optional
Set lform = ie.document.forms(0)
With lform
lform("username").Value = "****"
lform("password").Value = "****"
lform.submit
End With
ie.Quit
Set ie = Nothing
End Sub

[/vba]



Please help me with the remaining, excel vba or vbs anyway is fine with me, since my aim is to automate the process.
The site that i am trying to code in the url part is,
h ttps://extcitrix.wellpoint.com(pls remove the space between 'h' and 'ttps')

Please reply if you need any more details

Thanks in advance for your help.