XLL Programming

[John Link]

Where is the best place to get information on programming an xll (DLL for
Excel). I created one with numerous functions. However, I cannot figure
out how to program an array function. The examples provided with the Excel
Developers Toolkit to not cover this item.

Any help would be appreciated.
John
john...@cs.com

[Laurent Longre]

John Link wrote:
>
> Where is the best place to get information on programming an xll (DLL for
> Excel).

Except the SDK... I don't know.

I've written a page about XLL functions, but in French
(http://longre.free.fr/pages/prog/api-c.htm), but... in French, sorry.

> I created one with numerous functions. However, I cannot figure
> out how to program an array function. The examples provided with the Excel
> Developers Toolkit to not cover this item.

You have just to store the results in an xltypeMulti XLOPER, set the
xlbitDLLFree of its type field and return a pointer to it. Then you free
the memory allocated to this XLOPER in xlAutoFree (see p. 241 of the
SDK). If your function uses an OPER array (type "P") instead of XLOPER
as argument, you can store the results of your function in this array
and return a pointer to it without freeing its memory (Excel will do it
automatically).

Do you want an example ?

Laurent

[Sam]

There are a dozen or so articles in MSDN on XLL. If you are still looking, search at http://msdn.microsoft.com

Good luck.

Sam

"John Link" <jml...@compuserve.com> wrote in message news:8b57g3$mtg$1...@news5.fast.net...

| Where is the best place to get information on programming an xll (DLL for

| Excel). I created one with numerous functions. However, I cannot figure

| out how to program an array function. The examples provided with the Excel
| Developers Toolkit to not cover this item.
|