Companies House DISSOLVED Companies.

Hi,

I am hoping someone can help me,

I am looking for help creating a macro to run a search of around 100 company numbers against the status of the companies on companies house and display this along side the company numbers on excel (Dissolved, Active, Liquidation or Administration). I would like to be able to run this daily to regularly keep it updated.

I am beginner using VBA and have spent hours looking at a way to do this.

Any help would be greatly appreciated, and can create a new workbook to upload if this is possible.