LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 358
Default 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
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
Can future dates on Excel be managed in Outlook calendar? larryf Excel Worksheet Functions 0 November 15th 06 03:13 PM
add ins - i've managed to uninstall from excel but the thing still shows up when excel opens in msie 6?? msnews.microsoft.com Setting up and Configuration of Excel 1 March 15th 05 09:24 PM
.Net Managed Code - Excel Francois[_3_] Excel Programming 0 August 12th 04 07:37 AM
Problem with optional parameters in Excel Automation Add-in worksheet function Mike Gilkeson Excel Programming 0 February 18th 04 02:13 PM
Excel Automation Find/Replace Excel 2000 and 2003 scorpion53061 Excel Programming 0 January 30th 04 10:13 PM


All times are GMT +1. The time now is 11:42 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"