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

[Nour]

• 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

 

[Marc L]

Hi !

To create your code, there are tutorials on Web like Web Scraping tutorial …

Must see too :
• Power Query : Import Data from Web Pages
• Pull data into Microsoft Excel with Web queries

• Using the F12 developer tools
• Analyzing your webpage's network traffic …

For inner Excel features, don't forget the Macro recorder !
​

 

[Nour]

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

 

[Chihiro]

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.