Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> Visual Studio Tools for Office >> Visual Studio Tools for Office

Custom descriptions for UDF

Hi, I would like to add custom descriptions for my user defined functions that appear in the build-in function wizard in Excel. In particular the individual arguments - something like the xll created athttp://xcell05.free.fr/ except I would like to do this with managed code if possible. Thanks!
[382 byte] By [bowman] at [2007-12-17]
«« DLINQ do not puts [] in "INSERT INTO" statement fields
»» Does Anyone want to work together?
# 1
Hi

XLL's in managed code is not that well supported at the moment, there are some tool vendors that have wrappered this in a more friendly environment, additionally there is a great article in Eric Carters blog about automated addins that may help if yo have the correct versions of Excel

http://blogs.msdn.com/eric_carter/archive/category/4620.aspx

Regards

MikeWalker at 2007-9-8 > top of Msdn Tech,Visual Studio Tools for Office,Visual Studio Tools for Office...
# 2
Hi, thanks for your response. Let me back up a bit, are there any properties or methods exposed by the Excel 2003 PIA from VB.NET that I can access to set a new function with descriptions of the arguments? I assume that the xll I referred to above and the vendor tools you mentioned make API calls, so you can't do this in .NET? Thanks.
bowman at 2007-9-8 > top of Msdn Tech,Visual Studio Tools for Office,Visual Studio Tools for Office...
Visual Studio Tools for Office

Visual Studio Tools for Office Hot Topic

Visual Studio Tools for Office New Topic

Visual Studio Tools for Office

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified