Using Excel and VBA to get API/Web Data with Multiple Queries

Hello all,

This is my first post and I would be grateful if you could help me . I have spreadsheets with a large amount of data for querying. I am looking for each cell of data to be searched through API/Web Query and then resultant from that specific data to be extracted to Excel. What is the best way to go about searching multiple queries so to speak? Would it have to be combined with a macro which searches one cell after another?

I appreciate your help.

I have attached a sample file along with the URL which needs to be queried.

Thank you!

Thanks for the reply. Initially I was just looking for the name of the director, as I have a file to VLOOKUP the addresses.

It works on the active sheet.
Should have valid nos on column A and result will be on column B.

If you're after something a bit more comprehensive, I made a VBA wrapper around the companies house API here: http://www.excelforum.com/tips-and-t...house-api.html it is in beta though so don't blame me if it breaks!

Hi, no it works with post or get, the dom is completely unrelated to the request. There shouldn't be an issue with tagname, I'll have a look at your code when I'm in front of a computer

Hi Kyle,
I managed to avoid a loop, but could easily error if the H2 is changed.

Originally Posted by AB33

Hi Kyle,
I managed to avoid a loop, but could easily error if the H2 is changed.

That's why it's better to use the api rather than web scraping. The api won't change, they're published to a specification