Add .NET control

[HarryX]

Hi, I need to add a .NET usercontrol to Excel in the same way as you can with
COM.
I have looked at Shared Addin's but don't know how I would implement the
usercontrol.

Any help would be useful....Thanks

 

[XL-Dennis]

Hi Harry,

Yes, it's possible to use a Shared add-in however it's important that You
make a complete setup of it.

I've recently publish 9 articles about creating and deploying COM Add-ins
with VB.NET 2005 and the following URL is the startpage:
http://www.excelkb.com/article.aspx?id=10204

BTW, which user control in .NET do You intend to use?

 

[HarryX]

Thanks Dennis I'll take a look.

Basicaly I have a .NET sample application for Tablet PC Ink, which I intend
to convert to a usercontrol and use in Excel as a control.

Nick...

 

[XL-Dennis]

Nick,

OK, let us know how it progress and if You get some problems.

 

[HarryX]

Thanks Dennis.

It has been a while since I have written a COM object!!! I am strugling to
get my head around the best way to attack this.

I need to add functionality to a control (eg TextBox) and be able to load it
into Excel as a control. The added functionality will be written with C# .NET

If my control was C++ then a normal COM object would surfice, but as I need
..NET then I think I need to use the Shared Addin and implement the control (I
think)
I am trying to find an example of how to implement a derived control which
can be loaded into Excel as an object.

Does anyone have any suggestions which is the correct approach/examples?

Thanks again.

 

[XL-Dennis]

Nick,

In view of Your last post I suspect that the best approach would simple be
to write an ActiveX control with C#.

Here is a link to an 'introduction' to writing an ActiveX control in .NET
(C#):
http://www.c-sharpcorner.com/Code/2003/March/ActiveXInNet.asp

 

[Andrei Smolin]

Harry,

From your description I can't say for sure if our products are of use

to you. Nevertheless, I hope that the following info might be
interesting for you: our Toolbar Controls for Microsoft Office allows
placing a .NET UserControl on an Office toolbar (CommandBar object).
See http://www.add-in-express.com/office-toolbar-controls/.

BTW, we are working on the product that will allow adding custom .NET
forms as sub-panes of the main Excel window.

Andrei Smolin
Add-in Express Team Leader
www.add-in-express.com