Web Scrap name from a webpage

[Brawnystaff]

I have a spreadsheet with various identifying numbers (called NPIs) in column A (see attached). I am using the following website to lookup the name for each NPI number and place in column B:

https://npiregistry.cms.hhs.gov/

I notice after I type in the NPI number and click search, the resulting URL is always the same: https://npiregistry.cms.hhs.gov/regi...iew/xxxxxxxxxx with the x value being the NPI number. Is there a way to extract the name automatically without having to lookup each provider?

Alternatively, I notice they have an API do accomplish this with JSON, but not sure how to integrate with Excel. The API webapge is at the following URL:

https://npiregistry.cms.hhs.gov/registry/help-api

Finally, I had solved this some time ago with another method as outlined in the link Excelforum.com link below, but they recently changed the website around which make the solution no longer work.

http://www.excelforum.com/showthread...80#post3539780

Any help is appreciated...