Excel 2007 Add-in with VSTO
 

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.

Excel 2007 Add-in with VSTO
 

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"MadZebra" wrote in message
...
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.

Excel 2007 Add-in with VSTO
 

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.

"Jon Peltier" wrote:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"MadZebra" wrote in message
...
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.

Excel 2007 Add-in with VSTO
 

the requirement is for an add-in.

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

--
Jim
"MadZebra" wrote in message
...
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.

"Jon Peltier" wrote:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"MadZebra" wrote in message
...
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.

Excel 2007 Add-in with VSTO
 

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!

"Jim Rech" wrote:

the requirement is for an add-in.

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

--
Jim
"MadZebra" wrote in message
...
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.

"Jon Peltier" wrote:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"MadZebra" wrote in message
...
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.

Excel 2007 Add-in with VSTO
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"MadZebra" wrote in message
...
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!

"Jim Rech" wrote:

the requirement is for an add-in.

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

--
Jim
"MadZebra" wrote in message
...
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.

"Jon Peltier" wrote:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"MadZebra" wrote in message
...
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.