I'm just beginning to use arrays and have a question:

I have created an array in VB using data from an Excel
spreadsheet. The array is populated just like I expect.
I then want move to a legacy program to populate the
legacy program with the data from the array for the first
item, then the second, third, etc. However, the array is
not visible in the "locals" window when I move to the
legacy program. It appears that it is being deleted or
lost.

Previously, I was able populate variables, move to the
legacy program, write the variable, move back to the
spreadsheet, move down a row, repopulate the variables and
then write the new variable in the legacy program.

I was hoping to move once to the legacy program and
populate a number of different rows using the array.

Any help you can provide with stopping the array from
going away would be greatly appreciated.

Mike,

Is the legacy program an Excel app, or something completely different?

Is the array declared as a public variable?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"mike" wrote in message
...
I'm just beginning to use arrays and have a question:

I have created an array in VB using data from an Excel
spreadsheet. The array is populated just like I expect.
I then want move to a legacy program to populate the
legacy program with the data from the array for the first
item, then the second, third, etc. However, the array is
not visible in the "locals" window when I move to the
legacy program. It appears that it is being deleted or
lost.

Previously, I was able populate variables, move to the
legacy program, write the variable, move back to the
spreadsheet, move down a row, repopulate the variables and
then write the new variable in the legacy program.

I was hoping to move once to the legacy program and
populate a number of different rows using the array.

Any help you can provide with stopping the array from
going away would be greatly appreciated.