Populate Search Box and then Scrape Web Site for result

  • I am trying to automate the 'Search' box on the following website "https://www.blackwoods.com.au". I have tried to modify original source code from "xl-searchbot.xlsm" from http://automatetheweb.net/", but having no luck in actually getting the 'Search' box to be populated. My understanding of the html and DOM structure is limited and I have being trying for the last 2 days with no luck.


    This is the HTML Extract for what I believe is the particular area of the DOM that I need to interact with.

    I would aApprecaite any help or advise.

  • Hi Gizzmo,


    please use below code:


  • You both need to read the Forum Rules.


    We do not allow questions on web scraping

    Quote

    5c. Web scraping. Ozgrid will not assist you in systematically acquiring data (even in the public domain) from a other peoples websites. We will show you how to do excel/browser automation with generic examples and answer specific questions related to browser automation VBA methods