adding automations to Excel (doesn't seem to work properly) !

[joseph_doggie]

successfully created an Add-in set called "ExcelAddIn2.MyFunctions"; and
added it.


This was following the book "Visual Studio Tools for Office Using C# with
Excel, Word, Outlook, and InfoPath" by Eric Carter & Eric Lippert (sometimes
called Eric2). See especially pp. 88-89 in the 2006 Pearson Education
edition.





However, when I created a new project, e.g. "ExcelAddIn3.TheseFunctions",

I use the Automation function, scroll down the list, and find it.



I check the appropriate box in the "Add-Ins" dialog box (or list box or
whatever form it is).



However, when I use insert->function -> Or Select a category and scroll
down, it is absent.



I also have found the same true of add-ins I've downloaded from the web.
For these, I store in a known sub-directory, then use Tools->AddIns
("Browse" button), find the appropriate file in the subdirectory.



Once again, I check the appropriate box in the "Add-Ins" dialog box, but
similary when I go to insert->function -> Or Select a category and scroll
down, it also is absent.



I've tried removing the "ExcelAddIn2.MyFunctions" -- thankfully it comes
back when I restore it ; I've tried re-booting and so forth.

Does anyonoe have any idea what the problem is?



Also, how does one remove "Add-Ins available" from the aformentioned Add-Ins
dialog box (obtained by using Tools--> AddIns)?



NOTE: I am using VSTO, Microsoft Visual Studio 2008, and Microsoft Office
(Proffesional Edition 2003) including the Microsoft Excel 2003.



Does anyone know of a link (URL) that would help?



Thread discussion: To do anything at all with VSTO, one needs to be able to
use an add-in in the appropriate office program, e.g. Excel. However, if
this thread belongs elsewhere please let me know where I should put it.



Thanks in advance, (-:

 

[Smallweed]

This sounds familiar - don't know if it's the same problem because we had it
with .NET, not C#, but when running an addin this way (which we'd developed
under Framework 2) in we had to run a patch to allow Excel to understand the
add-in because it can only use Framework 1.1. Might be worth googling that
because I don't know any more than that.