Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to work with a couple of CSV files that have at least 350,000 rows --
too many to bring into Excel 2003. I can easily enough parse the columns into an array, but I need to change the sorting so that I can then find a given value in the array/table. If I do this with a simple row-by-row comparison, it will take far too long. I found code that sorts long lists very fast(http://www.devx.com/vb2themax/Tip/19470), but it is designed to work on a single value per row. I can't easily figure out how to adapt it to my needs so that it will sort a two- or three-column table. Can anyone help? This is an enhancement to a large Excel macro. Changing entirely over to Access is not an option. However, it's possible that enough of the users will have Access on their machines that I could call Access from Excel VBA. I'm checking into that now. -- Gregg Roberts |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Loading data into an array | Excel Programming | |||
Loading array into list box | Excel Programming | |||
Count rows in text file by loading into array | Excel Programming | |||
Loading Excel Array from VB Array Faster | Excel Programming | |||
Loading 3 Dimensional Array | Excel Programming |