Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 339
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Shared Workbooks-shared headers and footers Sherry New Users to Excel 1 June 13th 08 03:59 PM
Issues with shared vs. non-shared formulas on somewhat wide spreadsheets david.karr Excel Discussion (Misc queries) 0 August 16th 07 12:52 AM
Printing viewing a shared workbook on a shared drive aloomba Excel Discussion (Misc queries) 0 April 13th 07 02:52 PM
update pivot in shared shared workbook 00George00 Excel Discussion (Misc queries) 1 August 23rd 06 08:16 PM
Excel automation and shared workbooks Matthew L. Butcher Excel Programming 0 December 4th 03 02:58 AM


All times are GMT +1. The time now is 05:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"