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.
To extract the Sales Rep ID from the Sales Journal, use the field name SALESREPID. Peachtree's documentation erroneously lists this field name as SALESREP.
Be sure to convert dates from Microsoft Excel spreadsheets to text before poking transactions into Peachtree. Spreadsheets store dates as serial numbers, which Peachtree won't accept.