How to click on Submit button using VBA

Question

I have a webpage on which i want to autologin and click on submit button using vba the code is below

'start a new subroutine called SearchBot
Sub SearchBot()

    'dimension (declare or set aside memory for) our variables
    Dim objIE As InternetExplorer 'special object variable representing the IE browser
    Dim aEle As HTMLLinkElement 'special object variable for an <a> (link) element
    Dim y As Integer 'integer variable we'll use as a counter
    Dim result As String 'string variable that will hold our result link

    'initiating a new instance of Internet Explorer and asigning it to objIE
    Set objIE = New InternetExplorer

    'make IE browser visible (False would allow IE to run in the background)
    objIE.Visible = True

    'navigate IE to this web page (a pretty neat search engine really)
    objIE.navigate "mywebpage"

    'wait here a few seconds while the browser is busy
    Do While objIE.Busy = True Or objIE.readyState <> 4: DoEvents: Loop

    'in the search box put cell "A2" value, the word "in" and cell "C1" value
    objIE.document.getElementById("loginID").Value = ("userid")
    objIE.document.getElementById("password").Value = ("password")

after this code i want to click on submit button using vba

HTML inspect element code is below

<INPUT class=btn2 type=submit value=Submit name=submit1>

<INPUT class=btn2 type=submit value=Submit name=submit1>

MoRizwan
– MoRizwan

2017-12-01 10:26:15 +00:00
Commented Dec 1, 2017 at 10:26 — MoRizwan
– MoRizwan, Commented Dec 1, 2017 at 10:26

J.B. · Accepted Answer · 2017-12-01 10:31:32Z

1

Try finding element by name and click it.

objIE.document.getElementsByName("submit1")(0).click

answered Dec 1, 2017 at 10:31

J.B.

4451 gold badge4 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

MoRizwan Over a year ago

Thanks J.B. it works , it is the same way to click on below code like <A class=level1 href="/pretups/scheduledReportAction.do?method=loadFirst&module=C2S&moduleCode=DWNLDRPT">Download reports</A>

J.B. Over a year ago

stackoverflow.com/questions/24638533/…

MoRizwan Over a year ago

Hello @J.B. can you please provide solution from your side.

Collectives™ on Stack Overflow

How to click on Submit button using VBA

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related