Board index » delphi » Passing Delphi Variant Arrays as parameters in Excel macros

Ramzan Mulji

Delphi Developer
Sat, 08 Jun 2002 03:00:00 GMT

Passing Delphi Variant Arrays as parameters in Excel macros

Hi

Does anyone know how I can pass an array of integers as a parameter in an
Excel Macro.

I have tried the following but I get a Type Mismatch error during runtime.

From Delphi:

VWidths := VarArrayCreate([0,10],varInteger);
....
....
OleVariant(xla).Run('DoReportSetup',VWidths);

In Excel my macro is declared as :

Sub DoReportSetup(iWidths As Variant)

Regards
Ramzan

 
Ron Loew

Delphi Developer
Sat, 08 Jun 2002 03:00:00 GMT

Re:Passing Delphi Variant Arrays as parameters in Excel macros


Try passing varVariant as the 2nd parameter of VarArrayCreate.

Ron.

--
Ron Loewy - List of Articles -
http://members.home.net/rloewy/RonPubList.html

Quote
Ramzan Mulji <rmu...@channel4.co.uk> wrote in message

news:83of00$j7i10@forums.borland.com...
Quote
> Hi

> Does anyone know how I can pass an array of integers as a parameter in an
> Excel Macro.

> I have tried the following but I get a Type Mismatch error during runtime.

> From Delphi:

> VWidths := VarArrayCreate([0,10],varInteger);
> ....
> ....
> OleVariant(xla).Run('DoReportSetup',VWidths);

> In Excel my macro is declared as :

> Sub DoReportSetup(iWidths As Variant)

> Regards
> Ramzan

Roger Morto

Delphi Developer
Sat, 08 Jun 2002 03:00:00 GMT

Re:Passing Delphi Variant Arrays as parameters in Excel macros


Quote
In article <83of00$j7...@forums.borland.com>, Ramzan Mulji wrote:

> I have tried the following but I get a Type Mismatch error during runtime.

> From Delphi:

> VWidths := VarArrayCreate([0,10],varInteger);
> .....
> .....
> OleVariant(xla).Run('DoReportSetup',VWidths);

> In Excel my macro is declared as :

> Sub DoReportSetup(iWidths As Variant)

Ramzan

Try

VWidths := VarArrayCreate([0,10],varVariant;

Roger Morton
roger.mor...@dial.pipex.com

Other Threads

1. passing array of variants as a parameter

2. Passing a Delphi Variant array to VB

3. Fastest way to append a variant array to a variant array

4. variant arrays of variant arrays

5. Passing Excel arrays to a Delphi DLL

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

7. How to Pass Parameters From IDE with Macros

8. How to pass parameters to a Word macro

9. Passing parameters to a Macro.

10. Problem with passing variant array from DLL