+ Reply to Thread
Results 1 to 1 of 1

Need to click on search button in a website using vba.

  1. #1
    Registered User
    Join Date
    03-11-2017
    Location
    India
    MS-Off Ver
    MS Office 2013
    Posts
    1

    Need to click on search button in a website using vba.

    I tried several methods to click the submit button using vba macro but not a single method worked for me. Finally i decided to post my concern here to seek advice.

    The website is realtor.com

    I populated the search box with my data from excel sheet using vba. now i am unable to hit the search button.

    i tried with the following vba code

    Dim objTag As Object
    For Each objTag In html.getElementsByTagName(strTagName)
    If InStr(objTag.outerHTML, "btn btn-primary js-searchButton") > 0 Then
    objTag.submit
    Exit For
    End If
    Next

    but it did not work for me


    It will be a great help for me if anyone helps me out here. Thanks in advance.
    Last edited by Tonmoy Roy; 03-18-2017 at 12:07 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Get Data from a Website - Unable to click Button
    By karan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2016, 04:45 PM
  2. Button Click on Spreadsheet commanded by Button Click on Userform
    By Quilie19 in forum Excel Programming / VBA / Macros
    Replies: 33
    Last Post: 04-07-2015, 11:35 PM
  3. [SOLVED] click on a color button and after button click it will color entire row of cell you click
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-11-2014, 06:06 PM
  4. VBA (Excel) code to click button on website
    By SteveCole in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-28-2013, 05:05 AM
  5. To Click on log in button of a website
    By sushil10s in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-01-2013, 01:20 AM
  6. IE and vba - click on search button
    By abousetta in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2011, 10:54 AM
  7. Click button on website from VBA
    By davegugg in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-12-2009, 05:25 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1