Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count rows in text file by loading into array
Hello --
The app can allow no more than 32,000 data points (1 column of numbers) to be imported using a text file. [1] Is there a way to load the file into an array, count the records loaded, and warn the user if 32,000 has been exceeded? [2] Then, if not exceeded, the app would then put the array values into a column in a worksheet. Can anyone help with ideas or sample code for doing [1] and [2]? Thanks for any help. Larry Mehl mehl_at_cyvest.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count how many different text values in an array. | Excel Worksheet Functions | |||
Need help with array formula to count rows w/ mult.criteria | Excel Programming | |||
Loading Excel Array from VB Array Faster | Excel Programming | |||
Loading 3 Dimensional Array | Excel Programming | |||
Loading text file | Excel Programming |