I need someone to create an excel page that automatically cross references company names against the companies house database via their xml gateway to get the company number and then cross references the company number against the database to return whether the company is bankrupt.
The excel spreadsheet should therefore have the following column headers:
Company Name, Company Number, Status.
I will then be able to add a list of 1000 companies to the company name column and the spreadsheet will show the company number and status.
The URL for the site is [Removed by [url removed, login to view] Admin], go to the webcheck section. The url for the xml gateway is [url removed, login to view]