ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   C# COM given "#NAME" error (https://www.excelbanter.com/excel-programming/385650-c-com-given-name-error.html)

Torben Laursen[_3_]

C# COM given "#NAME" error
 
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

C# COM given "#NAME" error
 
Torben,
Just a guess: Are you sure the user is using the correct function names ?

NickHK

"Torben Laursen" wrote in message
...
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





Torben Laursen[_3_]

C# COM given "#NAME" error
 
Nick,

Thanks, yes he send me screendumps.

Torben


"NickHK" wrote in message
...
Torben,
Just a guess: Are you sure the user is using the correct function names ?

NickHK

"Torben Laursen" wrote in message
...
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







Peter T

C# COM given "#NAME" error
 
Another guess, any simimilarly named functions around anywhere

Regards,
Peter T

"Torben Laursen" wrote in message
...
Nick,

Thanks, yes he send me screendumps.

Torben


"NickHK" wrote in message
...
Torben,
Just a guess: Are you sure the user is using the correct function names

?

NickHK

"Torben Laursen" wrote in message
...
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









Riccardo

C# COM given "#NAME" error
 

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" wrote:

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




Torben Laursen[_3_]

C# COM given "#NAME" error
 
Riccardo,
Thanks for the feedback. But it did not solve the problem.

Torben

"Riccardo" wrote in message
...

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" wrote:

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






Torben Laursen[_3_]

C# COM given "#NAME" error
 
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

"Torben Laursen" wrote in message
...
Riccardo,
Thanks for the feedback. But it did not solve the problem.

Torben

"Riccardo" wrote in message
...

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" wrote:

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









All times are GMT +1. The time now is 05:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com