C# COM given "#NAME" error

[Torben Laursen]

I have A COM add-in for Excel 2003 that is beeing used without any problems
on a number of computers.

However one of my customers cannot get it to work.
When he tryes to call one of the UDF in the COM he get the error: #NAME.

The COM seens to be installed correct. It addes a menu to Excel and he can
use the winforms that are in the COM.
Also there is no disabled items in Excel (Under Hep/About/Disabled items)
So everything seems to work except the user defined functions inside the COM

Can anyone give me any hints about how I solve this problem?

Thanks
Torben

 

[NickHK]

Torben,
Just a guess: Are you sure the user is using the correct function names ?

NickHK

 

[Torben Laursen]

Nick,

Thanks, yes he send me screendumps.

Torben

 

[Peter T]

Another guess, any simimilarly named functions around anywhere

Regards,
Peter T

 

[Riccardo]

hello, I have had a similar problem.

in my case the issue was that excel not using the correct version of the
..net framework.

I have resolved adding the text file excel.exe.config in the office folder
with the following rows
<configuration>
<startup>
<supportedRuntime version= " v2.0.50727 "/>
</startup>
</configuration>

 

[Torben Laursen]

Riccardo,
Thanks for the feedback. But it did not solve the problem.

Torben

 

[Torben Laursen]

I have solved the problem.

It turned out that the customer has installed Norton internet security 2007
and it was blocking the COM.
The solution is to disable the office plugin in Norton.

Torben