Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel v10 can't find function in C# .Net managed Automation add-in
When deploying a managed automation add-in to another machine (local file
system install and registration of add-in), Excel v10 (aka XP) will find the registerd add-in (tools-addins-automation) but the function will not appear in the function list and of course #NAME? results if try to use in the spreadhseet. The add-in works fine on machines with office v11 installed, and also works fine for Excel v10 on a machine with both office 2003, Office XP and vs2005 installed. (The function name appears in Insert Function list as expected). Even a simplified test program (no interfaces other than autodual) has this problem using System; using System.Collections.Generic; using System.Text; using System.Runtime.InteropServices; using Microsoft.Win32; namespace testfunc1 { [ClassInterface(ClassInterfaceType.AutoDual)] public class functions { public Double AJTE(Double a,Double b) { return (a+b); } [ComRegisterFunctionAttribute] public static void RegisterFunction(System.Type t) { Microsoft.Win32.Registry.ClassesRoot.CreateSubKey ("CLSID\\{" + t.GUID.ToString().ToUpper() + "}\\Programmable"); } [ComUnregisterFunctionAttribute] public static void UnregisterFunction(System.Type t) { Registry.ClassesRoot.DeleteSubKey ("CLSID\\{" + t.GUID.ToString().ToUpper() + "}\\Programmable"); } } } I am using win xp pro, vs2005, .Net Framework 2.x and all updates to all products in place. And here I was thinking I was ready to let it loose on clients....Any thoughts on what is going on? Jeltz. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can future dates on Excel be managed in Outlook calendar? | Excel Worksheet Functions | |||
add ins - i've managed to uninstall from excel but the thing still shows up when excel opens in msie 6?? | Setting up and Configuration of Excel | |||
.Net Managed Code - Excel | Excel Programming | |||
Problem with optional parameters in Excel Automation Add-in worksheet function | Excel Programming | |||
Excel Automation Find/Replace Excel 2000 and 2003 | Excel Programming |