Companies House API - search for companies, populate spreadsheet.

Kyle123 did some amazing work writing a lot of code to access the Companies House API within Excel. See the thread here: http://www.excelforum.com/showthread.php?t=1123818

While this works great for individual companies, it all gets a bit harder if you have a list of several thousand companies.

Would there be a way to make Excel take what is in column A, search for it, ask the human to select an option if there is more than 1 and then populate columns B-G from the results?

A B C D E F G
Company Name CRN SIC Sector Segment Postcode Address
Heptares Therapeutics
OXFORD NANOPORE TECHNOLOGIES
Immunogen International

Really appreciate your help!

Thank you

Wowser! Kyle, you're a star! Thank you so much for helping me with this. You've save me! Can I buy you a beer somehow?

Try swapping:

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

In CompaniesHouseRequest

Then I'm afraid I can't help, it's a config issue at your end on the network or your machine. PS, you shouldn't really be asking here - it's against the rules since it's not your thread