View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Jerry W. Lewis Jerry W. Lewis is offline
external usenet poster
 
Posts: 837
Default Creating Add-in with library of functions

It is indead possible (I have done it). If you model on GENERIC.C from
the Excel 97 SDK CD, the last argument in the g_rgWorksheetFuncs array
is the help string for the first argument (which gets reused for
subsequent arguments if no other help strings are registered). If you
supply additional arguments (some adjustment of demensions and loop
limits required), they will be interpreted as help strings for
additional arguments.

Jerry

Tom Ogilvy wrote:

Jerry told you how to do it for VBA UDF's. I believe you can in an XLL
although I have never built one, but Laurent Longre implies that it is
possible to do it directly in an XLL. XLL construction is covered in the
Excel Software Developer's kit, but that has been discontinued back around
xl97 I believe (or perhaps earlier). I believe the documentation is on
MSDN.