05-31-2006 10:36 AM
05-31-2006 11:48 AM
05-31-2006 12:03 PM
My requirement is a little complex
To build the array only by selecting the name of the files.
05-31-2006 12:12 PM
05-31-2006 01:50 PM - edited 05-31-2006 01:50 PM
Your mistake is in autoindexing the result of the Read From Spreadsheet into the 3D array. Instead, use a shift register and Build array to append the results of each read to the prior one. If you transpose the Read From Spreadsheet result, each new file will be added as new rows. Then when all have been read, do another transpose to get them back into columns.
Message Edited by Dennis Knutson on 05-31-2006 12:51 PM