How to pass data to a .dll

Mr930

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

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
585
I never heard of a XLL, guess I have some research to do!

thanks!
 

Forum statistics

Threads
1,141,012
Messages
5,703,729
Members
421,312
Latest member
Mooncake1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top