Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automation / Shared Add-in VS.NET
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 a 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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automation / Shared Add-in VS.NET
"Luis Simões" wrote in message ... 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 a 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 Ithink you should post this question to news:microsoft.public.office.developer.com.add_ins or news:microsoft.public.excel.sdk /Fredrik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shared Workbooks-shared headers and footers | New Users to Excel | |||
Issues with shared vs. non-shared formulas on somewhat wide spreadsheets | Excel Discussion (Misc queries) | |||
Printing viewing a shared workbook on a shared drive | Excel Discussion (Misc queries) | |||
update pivot in shared shared workbook | Excel Discussion (Misc queries) | |||
Excel automation and shared workbooks | Excel Programming |