All information returned by DDERequest is in the form of an array. To use the data in the array, you must either write the array to a cell, or use MyArray(1) to access the first item in the array, such as the current period number. In the case of distributions, which consist of 8 or 10 fields, you can use MyArray(3) to access the Item ID (the third item in the distribution), for instance, rather than post the whole array to a range of cells.
Mar 26