Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 VSTO - Why do I get 0x80010105 upon Excel.Close()? | Excel Discussion (Misc queries) | |||
Incomplete Office 2007 install? Where are .NET PIAs for Excel? Need VSTO? | Excel Discussion (Misc queries) | |||
office 2007 and vsto | Excel Programming | |||
VSTO 2003 and 2007 Add-ins | Excel Programming | |||
VSTO 2.0 vs Excel VBA | Excel Programming |