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
View: 134|Reply: 1

UK Companies House - VBA

[Copy link]

1

Topics

2

Posts

11

Integral

Member

Rank: 2

Integral
11
Post on 11-8-2017 05:13:11 | All posts |Read mode




Hi.


I'm more or less completely new in the area (and new in the forum).

Is there a chance to use VBA to pull out the basic information from Companies House? I would like to extract all the 'appointments' for a specific individual and have each company's information from the extraction.

Specifically:
| Company name
| Number
| Appointment date
| Resignation date (if any)
| Registered office date.
| Next accounts due
| Confirmation statement due
| Latest accounts registered.


Is this possible? Be amazed if so.


Thanks a lot!
Reply

Props Report

1

Topics

2

Posts

11

Integral

Member

Rank: 2

Integral
11
 Author| Post on 11-8-2017 05:17:31 | All posts
(latest accounts registered = DATE of the latest accounts registered).
Reply Support Opposition

Props Report

Points policy of this forum

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

GMT-5, 2-22-2018 23:02 , Processed in 0.289788 second(s), 23 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

!fastreply! Top !return_list!