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.

    Yours,
    Chandoo
  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

    Hui...

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

Trying to interact with a WebPage from within an Excel and extract some data

Discussion in 'VBA Macros' started by Nour, Dec 7, 2017 at 10:29 AM.

  1. Nour

    Nour New Member

    Messages:
    2
    • Hi All,

      I am trying to develop a macro that will:

      1. open a Web page (https://ethernetpricingtool.openreach.co.uk/QuickQuotes). Press the (Generate Quote). wait for the next page.

      2. Press the (Single Quote). wait for the next page.

      3. copy information (Post code) from excel and Paste into the text box.

      4. Press the (continue). wait for the next page.

      5. choose from the drop down lists and Press the (continue)

      6. Wait for the output data.

      7. Extract the output data off of the Web Page.

      8. Paste this data into an Excel workbook.

      Can anybody help out?

      Thanks

      Nour
  2. Marc L

    Marc L Excel Ninja

    Messages:
    3,276
    Nour likes this.
  3. Nour

    Nour New Member

    Messages:
    2
    Thanks for these resources, I have a good experience with using Power Query, web Query and Developer tools.
    the problem I am facing that the website is using "submit" button which I don't know how to deal with it.

    thanks
    Last edited by a moderator: Dec 7, 2017 at 4:50 PM
  4. Chihiro

    Chihiro Excel Ninja

    Messages:
    3,908
    You at least need to provide some valid examples of post code etc.

    I for one, don't want to spend time searching for one ;) I'm in North America and don't know off hand what's valid postal code for UK. What area the company services etc etc.

    Better yet, upload sample workbook of your set up and where you want the data loaded. And what you have done so far, and where it failed.
    Marc L likes this.

Share This Page