Hi,
I have written the VBA code to access a certain webpage & fill up the form there.
First of all I have opened a site, then clicked on the link given there.
But I am not able to fill in the inputs there.
Please sugget me what to do .....
My VBA code is as follows :
Private Sub CommandButton1_Click()
Dim IE As Object
Dim objelement As Object
Dim c As Integer
Set IE = CreateObject("InternetExplorer.Application")
IE.navigate "https://onlineservices.tin.egov-nsdl.com/etaxnew/tdsnontds.jsp"
While IE.busy
DoEvents
Wend
IE.Visible = True
On Error Resume Next
For i = 1 To IE.document.all.Length
If IE.document.all.Item(i).innertext = "CHALLAN NO./ITNS 280" Then
IE.document.all.Item(i).Click
Exit For
End If
Next i
Set IE = Nothing
End Sub
I have written the VBA code to access a certain webpage & fill up the form there.
First of all I have opened a site, then clicked on the link given there.
But I am not able to fill in the inputs there.
Please sugget me what to do .....
My VBA code is as follows :
Private Sub CommandButton1_Click()
Dim IE As Object
Dim objelement As Object
Dim c As Integer
Set IE = CreateObject("InternetExplorer.Application")
IE.navigate "https://onlineservices.tin.egov-nsdl.com/etaxnew/tdsnontds.jsp"
While IE.busy
DoEvents
Wend
IE.Visible = True
On Error Resume Next
For i = 1 To IE.document.all.Length
If IE.document.all.Item(i).innertext = "CHALLAN NO./ITNS 280" Then
IE.document.all.Item(i).Click
Exit For
End If
Next i
Set IE = Nothing
End Sub