Proper COM registration

[nogeek]

Hello,

I need you help.

I've developed a RTD server using C# and .NET framework for use in
Excel. As an output i have a .dll assembly. My class implements an
IRTDServer as written at MSDN.

The problem is that I can't register my COM component properly.

I've made my assembly COM visible.
I've run regasm as follows:

regasm RTDSrv.dll /codebase

Everything wen fine, and I've checked registry to see if COM was
effectively registered.

The problem is that RTD server works only on my station where I have
Visual Studio installed. On the others stations I get #N/A in the Excel
cells.

In Excel options my RTDServer appears as an Excel add-in with mscoree as
type.

What I'm missing? I'm using VS2005 and Excel 2007.
Thank you for your help.

 

[br73]

nogeek -

Have you had any luck with this issue? I have been trying to resolve the
same problem for a while now. I thought the issue may be that it required a
Shim dll, but after implementing one it did not seem to work. My current
solution is to just create a C++ COM component, it seems to be working, but I
would like to find an answer myself for using .NET assemblies.

Bryan

 

[daboul]

Hi,
it may not be related, but just in case, have a look at this kb:

http://support.microsoft.com/kb/908002

daboul.