ProgID of COM Ribbon

[Guido De Bouver]

hello Excel-DNA,

I understand the Excel-DNA Ribbon dynamically adds a COM AddIn.

One my clients needs to know the associated ProgID ?
Is this fixed ? HJow can I find this ?

Thanks for your much appreciated suggestions.

guido

[Govert van Drimmelen]

Hi Guido,

The ProgId comes from a call to Marshal.GenerateProgIdForType(...) (https://msdn.microsoft.com/en-us/library/system.runtime.interopservices.marshal.generateprogidfortype(v=vs.110).aspx).

The default ProgId is the FullName of the class (namespace.typename).

You can also explicitly assign a ProgId to the ExcelRibbon-derived class by adding a [ProgId] attribute.

There is also a mechanism in the xml to specify a namespace that is shared between ribbon elements. See the SharedGroup1.dna / SharedGroup2.dna pair in the Samples here: https://github.com/Excel-DNA/ExcelDna/tree/master/Distribution/Samples/Ribbon

Basically you set an xml namespace (myNameSpace) and then use the idQ attribute to name your ribbon elements. The namespace and idQ pair can then be shared between different add-ins to e.g. put extensions onto the same tab.

-Govert

---

From: exce...@googlegroups.com [exce...@googlegroups.com] on behalf of Guido De Bouver [guido.d...@mwgroup.net]
Sent: 15 December 2016 04:51 PM
To: Excel-DNA
Subject: [ExcelDna] ProgID of COM Ribbon

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