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
|