Newbie to Excel DNA - works with VSTO?

[Thor]

I see conflicting advice on using Excel DNA with a VSTO application.

What's the verdict? If possible, where are the instructions to implement?

I have a VSTO Excel Ribbon application that is giving me this error when building...

Assembly '\packages\ExcelDna.Integration.0.34.6\lib\ExcelDna.Integration.dll' must be strong signed in order to be marked as a prerequisite.

Any help appreciated...

[Thor]

actually if i DO NOT open it after this prompt, but then go into "Excel Add-Ins" and manually add it once inside Excel, it does work.

how can I get this to happen automatically?

[Govert van Drimmelen]

You can't combine Excel-DNA and VSTO in one add-in.

In particular, you can't use the Microsoft.Office.Tools.XXX assemblies in an Excel-DNA .xll add-in, though you can use the regular Microsoft.Office.Interop.Excel interop assemblies.

And you can't use any of the Excel-DNA libraries inside your VSTO Add-in.

However, you can make two add-ins, and load the Excel-DNA .xll add-in from the VSTO addin by calling Application.RegisterXLL(.....).

-Govert

CREModels.com

ph (201) 252-7487

100 Second Ave S

North Tower, 2nd Floor

St Petersburg FL 33701

CREModels proudly supports:

Great Explorations Children's Museum

CREModels is not a brokerage, law, accounting, engineering or investment firm. In no way should any communication from CREModels be deemed a recommendation from a licensed professional unless specifically stated as such.

--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com.
To post to this group, send email to exce...@googlegroups.com.
Visit this group at https://groups.google.com/group/exceldna.
For more options, visit https://groups.google.com/d/optout.

[Hugo Lyppens]

We have a solution containing both an Excel-DNA addin for worksheet functions and a VSTO addin for a ribbon add-in. Below you suggested loading the xll from a VSTO add-in. Is the reverse also possible? We'd like to avoid VSTO deployment problems by starting the VSTO addin in the AutoOpen of the Excel-DNA add-in. If this is a bad idea also let me know. I am aware they probably run in different app domains. Thanks.