Using reflection with c# and COM

Question

I'm trying to find all controls on a MSForm using c# and VBA Extensibility. My problem is that the 'generic' designer object from the VBE (Microsoft.Vbe.Interop) needs to inherit the Controls object from MSForm Interop (Microsoft.Vbe.Interop.Forms)).

This thread gives more details on my problem :

http://stackoverflow.com/questions/1200576/find-all-controls-on-msform-from-c

Is this even possible in C#?

Answer 1

Hi,

For discussions relating to office developing, I recommend you create a new thread at :

 http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.office.developer.automation&cat=en_US_e2055ea2-5150-47b0-ba98-c4fb85931ce0&lang=en&cr=US

You will get better and quicker responses from the experts there.

Best regards,
Harry

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 2

Thanks Harry. The problem is actually a C# problem and not office.

I have worked out that the problem is down to reflection. In VB.NET, this is automatically catered for, but in c# it is not.

So I need to figure out how to add the Controls collection to Microsoft.Vbe.Interop.VBComponent.Designer
at runtime. The controls collection is actualy part of another assembly (msforms) :

  foreach (Microsoft.Vbe.Interop.Forms.Control ctrl in Microsoft.Vbe.Interop.VBComponent.Designer.Controls)

Any ideas how I can accomplish this?