Passing an array to VBA (Excel)

c...@akg.th-darmstadt.de (Christian Koch)

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Passing an array to VBA (Excel)

Hello!

How do I pass an array from a Pascal-DLL to Excel?

My idea is to write fast code for a physics interface in Pascal,
pass the results as an array to Excel and use Excel to display
the results. I finally manage to pass integers, singles and
doubles, but just single parameters.

The problem starts when I pass an array. In the MSD-Docu they
show examples for interfacing with C where they use SAFEARRAYS
and calls to the SDK. Besides that it says an array is passed
from VBA to C as a pointer to a pointer. I tried some coding, but
didn't get too far (garbage values arrived when I passed arrays
from VBA to Pascal, Excel produced GPFs when I passed them from
the DLL to Excel).

Thanks for your help.

Christian Koch

William G. Roy

Delphi Developer

Sun, 26 Jul 1998 03:00:00 GMT

Re:Passing an array to VBA (Excel)

Quote

Christian Koch (c...@akg.th-darmstadt.de) writes:
> Hello!

> How do I pass an array from a Pascal-DLL to Excel?

> My idea is to write fast code for a physics interface in Pascal,
> pass the results as an array to Excel and use Excel to display
> the results. I finally manage to pass integers, singles and
> doubles, but just single parameters.

> The problem starts when I pass an array. In the MSD-Docu they
> show examples for interfacing with C where they use SAFEARRAYS
> and calls to the SDK. Besides that it says an array is passed
> from VBA to C as a pointer to a pointer. I tried some coding, but
> didn't get too far (garbage values arrived when I passed arrays
> from VBA to Pascal, Excel produced GPFs when I passed them from
> the DLL to Excel).

> Thanks for your help.

> Christian Koch

Do you have the Excel Development Kit?

The definition of the various parameters that Excell uses in external
function call is definied in the book. Although they are in C, conversion
to Delphi records (not classes) should be straightforward.

--
Bill Royds az...@freenet.carleton.ca
Ottawa, Ontario ROY...@EM.agr.ca Scientific Software Support

Other Threads

1. Does any one succeed to pass a array from C++ to excel(vba)

2. Parameter passing between Delphi DLL and VBA (Excel 5.0): Safearrays, XLOPER

3. Passing Excel/VBA Addressof function pointer to Delphi DLL

4. Excel - using Excel VBA to call functions stored in a Delphi COM Add-In

5. Passing Excel arrays to a Delphi DLL

6. Passing Excel arrays to Com

7. Passing Delphi Variant Arrays as parameters in Excel macros

8. Pass value from a Delphi DLL to a VBA application

9. Passing Strings between Delphi DLL and VBA

10. Global array in VBA