| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Shortcut key for "Paste Options" and "Error Checking" buttons? | Excel Discussion (Misc queries) | |||
| What is Error "Method "Paste" of object "_Worksheet" failed? | Excel Programming | |||
| "Clean Me" Macro is giving "#VALUE!" error in the Notes field. | Excel Programming | |||
| Getting "compile error" "method or data member not found" on reinstall | Excel Programming | |||
![Torben Laursen[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
