Companies House API tool to pull officer information and address

Hello,

I have seen a thread located here https://www.excelforum.com/tips-and-...house-api.html where Kyle wrote some coding to incorporate the Companies House API developer within a macro on microsoft excel.

I am simply looking at how I can use this to search a company name and number and have the results return an officer off the company and the address of the company.

Is anyone able to assist?

Kind Regards,

Same question here - can anyone post a working model please?