Custom ComAddin ProgId and Description?

[octamer]

Hello Excel-DNA community! 

I'm a newbie to Excel Addins development using .net 4.8 (for easier distribution). I'm trying to use VBA Application.RegisterXLL to load the add-in dynamically from certain Workbook templates. I noticed that when registered, the default ProgId in the Windows Registry is a random name like "Dna_b5ad37d83d5c5e15b712dedcccbc997e_0". Also, in the Excel Add-In management (Options - Addins), the description is "Dynamically created COM Add-in to load custom UI for the Excel Add-in {0}, located at {1}.". Publisher is "<None>". 

Is there a way to customize ProgId, Add-In description, and Publisher? 

[Govert van Drimmelen]

I think if you decorate the ExcelRibbon-derived class with both [Guid] and [ProgId] attributes, these will be used instead of the generated ones.

 

I think you can also set the FriendlyName and Description properties of that class in your constructor, then it will be used at registration time.

        public string FriendlyName { get; protected set; }

        public string Description { get; protected set; }

 

Let us know if this works.

 

-Govert

--
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 view this discussion visit https://groups.google.com/d/msgid/exceldna/1548327c-e725-4b5d-a831-69341798c259n%40googlegroups.com.

[octamer]

Hi Govert,  

Problem solved. I used the custom attributes and constructor. All working now! Thanks so much!