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,
Just a guess: Are you sure the user is using the correct function names ?

NickHK

"Torben Laursen" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>

Nick,

Thanks, yes he send me screendumps.

Torben


"NickHK" <(E-Mail Removed)> wrote in message
news:uVleG%(E-Mail Removed)...
> Torben,
> Just a guess: Are you sure the user is using the correct function names ?
>
> NickHK
>
> "Torben Laursen" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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
>>
>>
>
>

Another guess, any simimilarly named functions around anywhere

Regards,
Peter T

"Torben Laursen" <(E-Mail Removed)> wrote in message
news:uS#(E-Mail Removed)...
> Nick,
>
> Thanks, yes he send me screendumps.
>
> Torben
>
>
> "NickHK" <(E-Mail Removed)> wrote in message
> news:uVleG%(E-Mail Removed)...
> > Torben,
> > Just a guess: Are you sure the user is using the correct function names
?
> >
> > NickHK
> >
> > "Torben Laursen" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> >> 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
> >>
> >>
> >
> >
>
>

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
>
>
>

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

Torben

"Riccardo" <(E-Mail Removed)> wrote in message
news:1940CC6C-0CC5-494E-ABBE-(E-Mail Removed)...
>
> 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
>>
>>
>>

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Riccardo,
> Thanks for the feedback. But it did not solve the problem.
>
> Torben
>
> "Riccardo" <(E-Mail Removed)> wrote in message
> news:1940CC6C-0CC5-494E-ABBE-(E-Mail Removed)...
>>
>> 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
>>>
>>>
>>>
>
>