COMException (0x800A03EC)

[mobigital]

on some computers, I am getting this error in the RTD function
wrapper:

In some cases the error can be fixed by unchecking the add-in in add-
ins menu, click OK, then check again, click OK.
In those cases the error persists whenever a file is opened that
references the RTD wrapped function.
(not once when Excel is opened, but every time a new file is opened).

2/26/2009 9:25:17 AM Error in MyFunction:
System.Runtime.InteropServices.COMException (0x800A03EC): RTD method
of WorksheetFunction class failed
at System.RuntimeType.ForwardCallToInvokeMember(String memberName,
BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData&
msgData)
at Microsoft.Office.Interop.Excel.WorksheetFunction.RTD(Object
progID, Object server, Object topic1, Object topic2, Object topic3,
Object topic4, Object topic5, Object topic6, Object topic7, Object
topic8, Object topic9, Object topic10, Object topic11, Object topic12,
Object topic13, Object topic14, Object topic15, Object topic16, Object
topic17, Object topic18, Object topic19, Object topic20, Object
topic21, Object topic22, Object topic23, Object topic24, Object
topic25, Object topic26, Object topic27, Object topic28)

at MyClass.MyFunction(Object arg1, Object arg2, Object data1,
Object data2, Object data3, Object data4, Object data5, Object data6)
in C:\stuff\MyClass.cs:line 36

this error persisted in ExcelDna version 0-16, and also in 0-18

any help would be greatly appreciated

[mobigital]

I got this fixed, was a problem with RTD registration.
for some reason regasm.exe didn't store the assembly path in registry,
so excel could not find it, and would not look in the current
directory
where XLL was.

Once I added the path to registration nodes in registry it started to
work.

[Hmei]

Hi Mobigital,

I'm having same problems. Where do I add in the registration nodes in the registry and how do I figure where my registration nodes are?