Pull the HTML from multiple sites using VBA

[samcd87]

I have column A full of lots of URLs and they each return a basic string of text.

Two examples:

https://www.manchester.gov.uk/site/custom_scripts/bin_dates_gazops/index.php?uprn=000077002036

https://www.manchester.gov.uk/site/custom_scripts/bin_dates_gazops/index.php?uprn=000077002225

I am looking for a piece of VBA that would look at the first URL and pull the data, paste it in to column B and then move to the second URL and pull the schedule and so on until they have all been pulled.
Thanks in advance for any advice.

 

[Dan_W]

Well this is one of those occasions where you don't even need VBA or Power Query to do this - you can do it with a formula on the worksheet!
If the URL is in A1, and you want the text to output to B1, then put the following into B1:

=WEBSERVICE(A1)

and then it's easy enough to copy that formula down to the rest of the cells in the column. Let me know how you get on.

 

[samcd87]

This works well, thank you.