VBA Extract Data from Website Text

[theskyscraper1]

Hi,

Is it possible to extract the county code from this link:

https://geocoding.geo.census.gov/geo...14&format=json

I'm used to using the split function, but I can't get it to work for a website that is just text/for api. How can I modify this code:

Please Login or Register  to view this content.

If you know how to use it using VBA and API, that'd be amazing.

Here's the API information:

https://geocoding.geo.census.gov/geo...vices_API.html

Thank you. I can't find any information on how to do this. Thanks again!

[AlphaFrog]

Please Login or Register  to view this content.

[theskyscraper1]

Thank you. Your help was much appreciated.