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!
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!