Link VBA - DLL (in C): how to send an array as an argument?

[Sylvain]

Hi everyone,

I am working on an VBA application that needs to send an array as an
argument to an external libray written in C. The library uses the array
as a vector of parameters, and then returns a certain value.

The link is working well with a single argument (a double, an integer,
etc), by reference or by value. But when I want to send an array (a
vector of double for instance), it fails.

Does anyone know how to do this? First, is it possible?

Many thanks,

Sylvain

 

[Jerry W. Lewis]

The only way I have succeeded in passing or returning arrays is
abandoning the VBA declarations and writing an xll, per the SDK

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/office97/html/edkfrnt.asp

Jerry

 

[Sylvain]

Actually I found a way!

www.che.utexas.edu/cache/ newsletters/spring2001_useofc.pdf

It works for a vector of double.

I will also look at your solution

Thank you very much anyway

Sylvain