How to pass data to a .dll

Mr930

Well-known Member
Joined
Aug 31, 2006
Messages
583
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
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

hatman

Well-known Member
Joined
Apr 8, 2005
Messages
2,664
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
Code:
 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

Well-known Member
Joined
Aug 31, 2006
Messages
583
I never heard of a XLL, guess I have some research to do!

thanks!
 

Watch MrExcel Video

Forum statistics

Threads
1,113,850
Messages
5,544,656
Members
410,627
Latest member
georgealice
Top