Excel 2007 Add-in with VSTO

[MadZebra]

Hi,
I need to write an add-in for Excel 2007, but I'm a total noob to VSTO so
please forgive the dumb question. Unfortunately I can't find any demos
showing how to do what I want.
I started a new Excel 2007 add-in project and added a public function to the
base class, so I would expect to be able to call that function from an Excel
cell (e.g. =MyFunction(1,2,3) ).
Obviously this is an incorrect expectation because it doesn't appear in the
function list, so what exacly am I doing wrong?

Really appreciate all your help.

 

[Jon Peltier]

Could you do it in VBA? Generally it's much simpler.

- Jon

 

[MadZebra]

Yes I could, but unfortunately the requirement is for an add-in.
All the web pages I have found say this is straightforward, but when I do as
they say it doesn't work!
Maybe it's because I'm using VS2008, I don't know.

 

[Jim Rech]

the requirement is for an add-in.

You're aware you can create add-ins in Excel VBA?

 

[MadZebra]

Yes I saw that when I was playing, but I think the guy I'm doing this for (or
NOT doing it for at the moment!) has his heart set on a dll.
I'd really like to get this working correctly, as it kind of annoys me when
I can't figure something out. More of a challenge now that it was before!

 

[Jon Peltier]

The end user/customer should be concerned with the functionality, not
whether you use VBA or a DLL or XYZ to attain it. Sure, the method is
important, but they shouldn't lock you into a technique based on what
someone read in some magazine article, especially in a full color full page
ad in said magazine.

You can make a very elegant little add-in in VBA. If you *really* need to,
you could use VB6 to directly encapsulate the bulk of the add-in into a DLL.

- Jon