Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Chart-Objects don't work properly | Excel Programming | |||
Excel snap to feature does not work properly | Excel Discussion (Misc queries) | |||
Sorting in an Excel Chart won't work properly | Excel Discussion (Misc queries) | |||
My Excel is not adding properly, who can I tell? | Excel Discussion (Misc queries) | |||
The colors should work properly in Shared Excel Workbooks. | Excel Worksheet Functions |