1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.


Discussion in 'VBA Macros' started by Charlie Day, Feb 13, 2018.

  1. Charlie Day

    Charlie Day New Member


    I wanted to know if its possible in VBA to do Webscraping, this is what I'm looking for:

    1. The code to pick up a keyword from the cell of the excel sheet
    2. Open the pre-defined webpage
    3. Put that keyword in the pre defined place in the web page and click enter
    4. Record the metric as defined in excel sheet

    Just wanted to know if it's possible in VBA.

    p.s - the webpage is in javascript
  2. Marc L

    Marc L Excel Ninja

    Hi !

    It may be possible as it depends on webpage itself
    and upon your Excel version (Web inner features) …
    No generic code as nothing exists in original VBA.

    See the samples in threads within this forum (or everywhere on Web).

    A must read : Web Scraping archives
    shahin likes this.

Share This Page