03-14-2008, 04:43 AM
Hi Gindi,
I am using ExcelSheetToArray2 to bring in large sets of data. I then manipulate the values in the array. I then sort the array and divide it into smaller arrays. I would like to save these individually as Excel files. I think Ruby has something like this. Not that Ruby is otherwise any good. QM is much better!
Is there (or could you create?
) something like ArrayToExcelSheet? Ideally the function would create a new Excel file of location & name you determine. Alternatively, or maybe in a second function, you could send the array to a sheet in an existing file (ie, perhaps one you had already set up a pivot table or more formulas in).
-jimbog
I am using ExcelSheetToArray2 to bring in large sets of data. I then manipulate the values in the array. I then sort the array and divide it into smaller arrays. I would like to save these individually as Excel files. I think Ruby has something like this. Not that Ruby is otherwise any good. QM is much better!
Is there (or could you create?
) something like ArrayToExcelSheet? Ideally the function would create a new Excel file of location & name you determine. Alternatively, or maybe in a second function, you could send the array to a sheet in an existing file (ie, perhaps one you had already set up a pivot table or more formulas in). -jimbog