I am trying to pull some data from a website. I want to click a drop down button on the website "Select Payment Frequency" and select "YEARLY" from it. However, I am unable to select it. I have tried all combinations but am not able to do it. Please find below the code I am using.
Sub PC()
Dim ie As Object
Set ie = CreateObject("InternetExplorer.Application")
ie.Top = 0
ie.Left = 0
ie.Width = 800
ie.Height = 600
ie.Visible = True
ie.Navigate (http://www.iciciprulife.com/public/C...ne.htm?UID=497)
Application.Wait (Now + TimeValue("0:00:01"))
Do While ie.Busy
DoEvents
Loop
ie.document.getElementById("datepicker2").Value = “12/10/1997”
ie.document.getElementById("imobile").Value = "9987587821"
ie.document.getElementById("iEmail").Value = "jainsweta29@gmail.com"
ie.document.getElementById("closebalfund").Click
Application.Wait (Now + TimeValue("0:00:01"))
While ie.Busy
DoEvents
Wend
ie.document.getElementById("premium").Value = Premium
ie.document.getElementById("paymentFrequency").Value = "YEARLY"
While ie.Busy
DoEvents
Wend
End Sub
Sub PC()
Dim ie As Object
Set ie = CreateObject("InternetExplorer.Application")
ie.Top = 0
ie.Left = 0
ie.Width = 800
ie.Height = 600
ie.Visible = True
ie.Navigate (http://www.iciciprulife.com/public/C...ne.htm?UID=497)
Application.Wait (Now + TimeValue("0:00:01"))
Do While ie.Busy
DoEvents
Loop
ie.document.getElementById("datepicker2").Value = “12/10/1997”
ie.document.getElementById("imobile").Value = "9987587821"
ie.document.getElementById("iEmail").Value = "jainsweta29@gmail.com"
ie.document.getElementById("closebalfund").Click
Application.Wait (Now + TimeValue("0:00:01"))
While ie.Busy
DoEvents
Wend
ie.document.getElementById("premium").Value = Premium
ie.document.getElementById("paymentFrequency").Value = "YEARLY"
While ie.Busy
DoEvents
Wend
End Sub