Suggested C# Excel Add-In Architecture

M

mwieder

We are writing an Excel Add-In in C# that is a combination of our
custom Excel functions and dialogs to support those functions which
connect and retrieve data from our back end database. We need:
1) The functions to be usable as worksheet functions
2) A double click on a cell with one of our functions should bring up
our dialog for populating that function
3) To expose a connection to our database as a COM object for use in
VBA
4) To distribute just assemblies and no VBA

1 is accomplished through an Automation AddIn, 2 & 3 are accomplished
through a COM Add-In (I believe 3 can be done this way). Should we
have two seperate Add-Ins or group everything into 1 Add-In that gets
added both as a COM Add-In and as an Automation Add-In? We must
support Excel XP and above.

thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Found few bugs in my daily routine of work in excel for MAC 0
Found few bugs in my daily routine of work in excel for MAC 0
VSTO C# add in Outlook.Appointment error 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Autonumber field in Excel that behaves the same as Access 0
Which MS Program to Use? 0
Client Access File Transfer from Excel 2010 3
Com Add-In Modifying RIbbon in 2007? 1

Top