Excel Addin in VB.NET 2k3 - Basic customization

[.]

Hi,

I managed to create a COM addin for Excel with some UDF.

1/ I don't know how to change default Automation name ie

DLL_Name.Class_Name shown in Addin dialog box / Automation / Automation
Server List

For example, for Excel, it is "Microsoft Office Spreadsheet xx.x" not
Microsoft.Office.Spreadsheet ...

It can't figure how to change this default VB.NET behavior. Something in the
registry ?

2/ When adding an Automation Server, the same annoying name appears in
Avalaible Addin ie

DLL_Name.Class_Name

whereas Microsoft show Analysis Toolpak for example.

How to change to a more friendly name without destroying Registry ?

3/ After checking my Addin, a new funtion wizard group appears. Same geek
name ie

DLL_Name.Class_Name

How to change this default functions name group ?
Additionaly, say, I just want to add my UDF into Text function group, how to
obtain this result in VB.NET 2k3 ?

I don't have any clue on this. No internet ressouce on that really specific
issue so

any help welcome

Regards

 

[Dr. Stephan Kassanke]

The title in 2/ should be derived from the assembly, it should include an
entry

<Assembly: AssemblyTitle("your title goes here")>

Stephan