Automation / Shared Add-in VS.NET

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I managed to create a Shared Add-in in Vs.net 2003 and create all the menus,
UDFS and all that....

The only 2 problems i am having now are:
1 - The formulas seems to work only at second time ( I have to write a
formula like "=wew(.." for it to start accepting things from the add-in

2 - The add-in loading says that it can't find a mscoree.dll. what the hell
is this? I haven't created or used anything of that...

3 - I need to create a UDF that receives an unknown number of parameters.
In vba the PARAMARRAY works fine i have already checked that the .NET have it
to...
But the UDF don't get called by the excel. Here's an UDF sample in the add-in:

Public Function testingFunc(ByVal ParamArray var1 as Object ) as Object
testingFunc = "0"
End Function

Well if this was called the cell would contain "0" but nothing happens
because thought COM the paramarray seems not be working quite well or i miss
something...
The rest of the formulas using known parameters are working fine.

Some help would be really apreciated ;)

Best Regards,
Luis Simões
 
Luis Simões said:
Hi,

I managed to create a Shared Add-in in Vs.net 2003 and create all the menus,
UDFS and all that....

The only 2 problems i am having now are:
1 - The formulas seems to work only at second time ( I have to write a
formula like "=wew(.." for it to start accepting things from the add-in

2 - The add-in loading says that it can't find a mscoree.dll. what the hell
is this? I haven't created or used anything of that...

3 - I need to create a UDF that receives an unknown number of parameters.
In vba the PARAMARRAY works fine i have already checked that the .NET have it
to...
But the UDF don't get called by the excel. Here's an UDF sample in the add-in:

Public Function testingFunc(ByVal ParamArray var1 as Object ) as Object
testingFunc = "0"
End Function

Well if this was called the cell would contain "0" but nothing happens
because thought COM the paramarray seems not be working quite well or i miss
something...
The rest of the formulas using known parameters are working fine.

Some help would be really apreciated ;)

Best Regards,
Luis Simões
Click to expand...

Ithink you should post this question to

or

/Fredrik
 
Back
Top