+ Reply to Thread
Results 1 to 1 of 1

UK Companies House API Code by company name

  1. 03-26-2020, 10:00 AM #1
    joeburg
    joeburg is offline
    Registered User
    Join Date
    10-26-2018
    Location
    UK
    MS-Off Ver
    2016
    Posts
    20

    UK Companies House API Code by company name

    Hello!

    I found this thread which is close to what I need, but interested in one tweak.

    https://www.excelforum.com/tips-and-...house-api.html

    Is there any way to search for companies via name and it pulls the first result from the search into a cell?

    So I'd search for example "tesco" and it would pull back "Tesco PLC" and "00445790"
    Last edited by jeffreybrown; 03-26-2020 at 10:11 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. UK Companies House API Code
    By 19marc87 in forum Excel Programming / VBA / Macros
    Replies: 46
    Last Post: 12-17-2021, 07:53 AM
  2. UK Companies House API
    By Kyle123 in forum Tips and Tutorials
    Replies: 38
    Last Post: 03-24-2020, 11:08 AM
  3. Companies House API tool to pull officer information and address
    By chrisellis250 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-04-2019, 10:11 AM
  4. Companies House API officers company = dissolved
    By MacStokes in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-05-2018, 02:24 AM
  5. [SOLVED] Companies House DISSOLVED Companies.
    By MacStokes in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-24-2017, 02:10 PM
  6. Companies House Officer data
    By excelerators in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 03-13-2017, 07:22 PM
  7. Companies House API - search for companies, populate spreadsheet.
    By damnation in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-19-2016, 10:52 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1