I see that in the ExcelDna.dna (config) file I can set the "Name" of an XLL, which translates to the TITLE on the Excel/Options/Addins screen. But I was wondering if there was an easy way to set Comments (description) or Company name. Much thanks.
There is certainly not an 'easy' way. I recall seeing some (undocumented) registry keys that a COM add-in would write, and these seemed to work for an .xll add-in too.
For example, on my machine I see the Analysis ToolPak displays a description in the add-ins dialog - "Provides data analysis tools...". Searching for this string in the registry, I find a bunch of entries here:
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Classes\Installer\Components\B65A737451FC40A46A0FA969443BD207
but the relevant value is somewhat obscure:
zn=BVK(8A$!!!!!MKKSkExcelAddinATPFilesIntl_1033<Analysis ToolPak\Provides data analysis tools for statistical and engineering analysis
If you add an extra value under the same key it does get displayed in the add-ins dialog, but I couldn't get it hooked up with the actual add-in entry . . .