Hi Folks,

I am trying to pass an array variable of 601 points to an Excel sheet via ActiveX/formula object. I have tried the following code below but what it does is it places the first item of the array in all 601 cells.

The Excel sheet name is "TRACE DATA", the variable which is an array of 601 real numbers is in the array variable TRACEDATA_8563

Here is the code in the formula object:

ExcelApp.Sheets("TRACE DATA").Range("B1:B601").Value=TRACEDATA_8563;

Any suggestions will be appreciated.

Thanks

Damian.

dgoderich@gmail.com

I am trying to pass an array variable of 601 points to an Excel sheet via ActiveX/formula object. I have tried the following code below but what it does is it places the first item of the array in all 601 cells.

The Excel sheet name is "TRACE DATA", the variable which is an array of 601 real numbers is in the array variable TRACEDATA_8563

Here is the code in the formula object:

ExcelApp.Sheets("TRACE DATA").Range("B1:B601").Value=TRACEDATA_8563;

Any suggestions will be appreciated.

Thanks

Damian.

dgoderich@gmail.com

You can choose if your data should go vertical or horizontal before. Do you use ecxel lib for this? or in other words, what vee version are you using? 9.31 ?

detlef