Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 133
Default adding automations to Excel (doesn't seem to work properly) !

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.

"joseph_doggie" wrote:

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Chart-Objects don't work properly lapete Excel Programming 3 April 28th 08 07:14 AM
Excel snap to feature does not work properly rwhtx Excel Discussion (Misc queries) 0 December 6th 07 12:59 AM
Sorting in an Excel Chart won't work properly [email protected] Excel Discussion (Misc queries) 1 January 8th 07 08:09 PM
My Excel is not adding properly, who can I tell? Jeannette Excel Discussion (Misc queries) 2 October 12th 06 09:38 PM
The colors should work properly in Shared Excel Workbooks. [email protected] Excel Worksheet Functions 1 November 8th 04 10:55 PM


All times are GMT +1. The time now is 06:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"