How to create Automation Add In Formula/Function and Excel Add In buttons (vsto) for them together?

Posted by ticky on Stack Overflow See other posts from Stack Overflow or by ticky
Published on 2010-06-09T09:07:56Z Indexed on 2010/06/09 9:12 UTC
Read the original article Hit count: 255

Filed under:

excel

|

functions

|

vsto

|

udf

|

addin

Ok, let me explain it little bit better.

Here is one example how to create formula/functions

http://blogs.msdn.com/b/eric_carter/archive/2004/12/01/273127.aspx?PageIndex=1#comments

I implemented something like that, I even added values in registry, so that this Automation AddIn doesn't have to be added manually in Excel, but automatically..

I created SETUP project for this project and it works GREAT.

Then.. After some time, I wanted to create buttons in Excel for functions that I use. Those are custom functions, using some web services.

I created Excel AddIn and added Ribbon with buttons - one button = one custom function.

I can publish this project and I am creating VSTO, so this way, I can install excel ribbon buttons in custom group of mine.

Now, I have 2 installations, first for Automation AddIn and second for Excel AddIn.

How can I connect them?

I tried to include VSTO to Setup - something like this:

[I WILL ADD IT LATER]

When I install it, it works great, it installs both parts.

But when I install on my friends computer, it doesn't shows Ribbon buttons.

What could be the problem?
If there is some other way to integrate those two, I would be very grateful!!!!!

Thanks!

Tijana

Developer IT