Adding description to my vb.net excel shared add-in in function wizard

[Franck]

Hi,
Discovering that it's nearly impossible to add descriptions string to
my excel shared add-in functions in Excel's function Wizard, I've been
thinkin about a way... but I don't want to loose time so I require
advices.

So, I created a vb.net shared add-in with several functions... No big
deal => MyAddin.dll

Using Office Tool ComShimWizards, it created a VC++ dll shim for my
add-in => MyAddinShim.dll

And here is the point, In this project, there is a MyAddSin.idl file...

There is no interface about my functions but I'm wondering if it won't
help me to get descriptions in Excel function Wizard if I created an
interface in the file, mapping my functions and using the "helpstring"
tag.

So, here we go,Questions :
Am I stupid ? crazy ? Is it possible ? Samples ? Suggestions ?

Really need help.
Getting mad about @#! functions's descriptions...

 

[Fredrik Wahlgren]

Hi,
Discovering that it's nearly impossible to add descriptions string to
my excel shared add-in functions in Excel's function Wizard, I've been
thinkin about a way... but I don't want to loose time so I require
advices.

So, I created a vb.net shared add-in with several functions... No big
deal => MyAddin.dll

Using Office Tool ComShimWizards, it created a VC++ dll shim for my
add-in => MyAddinShim.dll

And here is the point, In this project, there is a MyAddSin.idl file...

There is no interface about my functions but I'm wondering if it won't
help me to get descriptions in Excel function Wizard if I created an
interface in the file, mapping my functions and using the "helpstring"
tag.

So, here we go,Questions :
Am I stupid ? crazy ? Is it possible ? Samples ? Suggestions ?

Really need help.
Getting mad about @#! functions's descriptions...

Hmm. I sthis an automation add-in? Maybe you have a combined COM/Automation
add-in. I don't think there is a shim wizard for automation add-ins. I think
this is possible. When you add a method in ATL, you can provide a
helpcontext which of course goes into the idl file. This is something that i
would like to try but I haven't had time to create some kind of dummy chm
file.

I don't think the Wizard has generated any code for your UDF's. You have to
do this yourself. I guess it's enough to simply add a class and the simplest
possible function to your shim and then try to use the "helpstring" tag.