View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
joseph_doggie joseph_doggie is offline
external usenet poster
 
Posts: 6
Default adding automations to Excel (doesn't seem to work properly) !

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, (-:



--
Joseph
a/k/a joseph_doggie