CH Client Officer list
Hi all,
Haven't had a chance to look at this lately but jumping back into it I now need to have the directors names (by this I mean all active directors of the company) listed in column 9 and cant figure out what I need to add, is it possible anyone could add this for me so that I can get this working?
Massive thankyou in advance!!!
Last edited by MacStokes; 01-04-2018 at 01:13 PM. Reason: Added Before & After
Jumping back into what? What is "this"? How would you like us to proceed? We are good, but we are not clairvoyant ...
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
dont you just type in the list in col.9?
or
copy /paste the list to col.9?
Where is column 9 coming from??? There is no workbook attached, not even images.
Apologies All KYLE123 posted a companies house client that he had built a wrapper round their API I amended this and added and removed what I needed all except Officers
should be 2 workbooks attached before and after
They are there now.
Ahhh was worried for a second
Like this:
Please Login or Register to view this content.
Kyle as always you are an absolute wizard! Thank you so much!!!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
That's brilliant could I get this to only show the relevant officers of each company currently it shows something like this...
Last edited by MacStokes; 01-04-2018 at 12:37 PM. Reason: added screenshot
As in removing the officers shown in the previous rows
Sorry, add in the following line:
Please Login or Register to view this content.
Its showing an error if it tries searching a dissolved company, I'm assuming this is due to having no active directors is there a way to skip the officer search if status = dissolved?
Last edited by MacStokes; 01-04-2018 at 02:45 PM.
Its showing an error if it tries searching a dissolved company, I'm assuming this is due to having no active directors is there a way to skip the officer search if status = dissolved?
Please continue in this thread - don't open any further duplicates. I've marked the thread as unsolved so you can get further help. You might want to adjust the thread title by editing the opening post.
Would anyone be able to help me I'm using a wrapper for the companies house API Kyle123 built to return company information and thanks to Kyle got this to populate officers names into column 9.
However when this runs into a company with a dissolved status the debug displays runtime error 5 which im assuming is down to the company being dissolved and having no active directors.
What i would like this to do is search the status column for any cells with the value dissolved and return the value "resigned" instead of running the officer search, effectively skipping any with the status value dissolved.
Last edited by MacStokes; 01-05-2018 at 04:37 AM.
I believed it was a separate issue as Kyle solved my initial query this would be to skip the officer search on a row if a cells value in column F was equal to dissolved.Originally Posted by AliGW
Irrespective of whether this is a new issue or not I will leave this thread open. Apologies.
It's just a follow-on question - makes more sense to continue here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks