PC Review


Reply
Thread Tools Rate Thread

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

 
 
joseph_doggie
Guest
Posts: n/a
 
      23rd Jul 2008
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 With Quote
 
 
 
 
Smallweed
Guest
Posts: n/a
 
      23rd Jul 2008
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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
embeded excel control doesn't work properly if excel workbook is open through GetObject("xx.xls") Zhiming H Microsoft Excel Programming 2 28th Oct 2008 01:22 PM
macro doesn't properly record AutoSum (and SendKeys doesn't work) =?Utf-8?B?Y3JpbXNvbmtuZw==?= Microsoft Excel Programming 2 21st Nov 2006 02:11 PM
Exteral Keypad for Notebook doesn't work properly with excel 2003 krmanji Microsoft Excel Crashes 2 3rd Nov 2006 11:56 PM
Excel 2000 to 2003 update links doesn't work properly any suggest =?Utf-8?B?UmljaGFyZA==?= Microsoft Excel Worksheet Functions 2 8th Sep 2005 01:06 AM
Excel 97 - Adding Every 8th Row - Formula should work, but doesn't Damaeus Microsoft Excel Worksheet Functions 12 23rd Jan 2005 04:52 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:18 AM.