How to pass data to a .dll

[Mr930]

I would like to write a .dll function that would accept a range as input. Actually all I need to pass is an array of numbers, I am using range as a generalization. My function would return a number. How would you pass a range (or array) to a .dll? The array would always be numbers.

thanks
Fred

 

[hatman]

You may wish to consider creating an XLL rather than a DLL since it can be opened directly by Excel.

In your function table, you would use a a "K" code for the Type Text in question The "K" code corresponds to an FP data type, which needs to be defined in your XLL as

 typedef struct _FP
{
  unsigned short int rows;
  unsigned short int columns;
  double array[1];
} FP;

The Excel 97 SDK on MSDN has a lot of info on building XLL's using plain c code.

And that's about as much as I know about that. Laurent Longre is one of the masters of XLL addins: http://longre.free.fr/

 

[Mr930]

I never heard of a XLL, guess I have some research to do!

thanks!

 

[hatman]

This is supposed to be a very good resource for XLL developement:

http://www.ebookmall.com/ebook/180126-ebook.htm