MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
12345
Return Post new threads
Author: 19marc87

UK Companies House API Code

[Copy link]

3

Topics

151

Posts

377

Integral

Conqueror

Rank: 3Rank: 3

Integral
377
Post on 10-5-2016 03:21:07 | All posts



@Marc
I've attached with a button on the worksheet to make it easier








  • CompaniesHouseClient Sample.xlsb
    (80.7 KB, 8 views)
    Download








  • Reply Support Opposition

    Props Report

    2

    Topics

    43

    Posts

    94

    Integral

    Member

    Rank: 2

    Integral
    94
     Author| Post on 10-5-2016 19:18:55 | All posts



    Hi Kyle
    Yes it does allow it, it has a separate API per client.
    Can you help me in adding an additional column on the spreadsheet for pulling the company registered number
    Thanks
    marc




    Reply Support Opposition

    Props Report

    6

    Topics

    732

    Posts

    1620

    Integral

    King

    Rank: 6Rank: 6

    Integral
    1620
    Post on 10-5-2016 19:26:25 | All posts



    This is my poor guess until Kyle pops in
    cll.Offset(0, 6).Value = company.Company_number
    Reply Support Opposition

    Props Report

    1

    Topics

    2

    Posts

    19

    Integral

    Member

    Rank: 2

    Integral
    19
    Post on 12-14-2017 07:25:17 | All posts
    Hi - could anyone help me with an adaption of these sheet that allows a user to input a company name in a say A1 and then in B1 the Search/Company API returns the first two results from Companies House with Company Name and Company Number? Thks
    Reply Support Opposition

    Props Report

    12345
    Return Post new threads

    Points policy of this forum

    Archiver|Mobile|Small dark house|Contact us|Excel Bar

    GMT-5, 2-21-2018 02:25 , Processed in 0.324376 second(s), 17 queries .

    Powered by Discuz! X3

    © 2001-2013 Comsenz Inc.

    !fastreply! Top !return_list!