magelan
11-26-2012, 09:20 AM
Hi All.
Trying to design a new program here. I have the UI built, but now it comes down to the code.
Essentially, this program is going to be reading 3 or 4 files of raw data lists that are 20 thousand lines or so long. I need to take all these lines, and copy them into a new workbook, as well as perform some operations on a specific column. Here's my question...
Should i copy all the data into an array and then either output a list, perform my operations, and save that list as the new workbook? I'm kind of nervous about this because a program that does 10k lines already takes 15 seconds to run [and this would be 60k lines...] though the user has apparently no problem with it taking a while [considering it takes hours and hours to do it by hand]
Or should I copy all the data into a new workbook, and then just operate on that [without an array or building a new list..]. This sounds like the best method to me, and I know how to open a second workbook with VBA, but not how to then copy a sheet into a third workbook.
How would you design this to work most effectively?
Trying to design a new program here. I have the UI built, but now it comes down to the code.
Essentially, this program is going to be reading 3 or 4 files of raw data lists that are 20 thousand lines or so long. I need to take all these lines, and copy them into a new workbook, as well as perform some operations on a specific column. Here's my question...
Should i copy all the data into an array and then either output a list, perform my operations, and save that list as the new workbook? I'm kind of nervous about this because a program that does 10k lines already takes 15 seconds to run [and this would be 60k lines...] though the user has apparently no problem with it taking a while [considering it takes hours and hours to do it by hand]
Or should I copy all the data into a new workbook, and then just operate on that [without an array or building a new list..]. This sounds like the best method to me, and I know how to open a second workbook with VBA, but not how to then copy a sheet into a third workbook.
How would you design this to work most effectively?