Add in project type

Add-in Express™ Support Service
That's what is more important than anything else

Add in project type
Com add in and udf 
Pierpaolo Paparo


Guest


Hi,
I am new to add-in express.
All I want to do is to develop an add-In that in addition to custom ribbon controls an dtasks pane, it will expose also some custom udf. Those udf will also make use of the excel object model, such as looping through tables to find values to query .net objects.
What should I do? To my understanding reading the user guide, there are technical difficulties developing both a comm addi and and excel com automation module, while Xll functions are not reccomeded when using calls to the excel object module. What does this exactly mean?

I hope my question is clear. Many thanks

Pierpaolo
Posted 03 Jul, 2012 07:34:44 Top
nwein




Posts: 577
Joined: 2011-03-28
You can read about it http://www.add-in-express.com/creating-addins-blog/2010/03/24/addin-xll-rtd-one-assembly/, just ignore the RTD portion of it.
Hope it helps but I'm sure Eugene or Andrei will reply as well.
Posted 03 Jul, 2012 10:16:28 Top
Eugene Astafiev


Guest


Hi Pierpaolo,

You are right; we don't recommend using the Excel Object Model in your UDFs. You can read more about this in the http://www.add-in-express.com/docs/net-excel-udf-tips.php#excel-object-model-xll section of the online documentation. Also please take a look at the http://www.add-in-express.com/creating-addins-blog/2010/03/24/addin-xll-rtd-one-assembly/ article on our technical blog (the link was published above, thank Nir).
Posted 03 Jul, 2012 14:05:04 Top
Pierpaolo Paparo


Guest


hi,
Thanks for your answer.
Would it e compliant with your recommendation of not using the excel object model to call

Module.CallWorksheetFunction???

In order to use other Xll from the one I am developing?

Please see your post below


http://www.add-in-express.com/forum/read.php?FID=5&TID=4266
Posted 04 Jul, 2012 02:05:54 Top
Eugene Astafiev


Guest


Hi Pierpaolo,

Yes, of course. You can use the Module.CallWorksheetFunction method in your UDFs.
Posted 04 Jul, 2012 06:26:04 Top