bdl004
07-14-2010, 12:11 AM
Hi Guys,
I am having some trouble with some VBA code that is supposed to read a text file in to three arrays by column. The problem is set up as follows:
There is a text file called test.txt that has series of numbers over "n" columns (specified by user). The vba sub must read the first column in to one array, the second column in to a second array, and then nth column in to a third array. The text file is tab and space delimited and contains around 10 000 rows of data.
My problem is that I don't know how to open the file delimited with tab and space and then read the data in to several arrays using VBA memory without writing the data to a sheet (I want to avoid this as it takes a very long time to process this much data).
Any help is greatly appreciated!
I am having some trouble with some VBA code that is supposed to read a text file in to three arrays by column. The problem is set up as follows:
There is a text file called test.txt that has series of numbers over "n" columns (specified by user). The vba sub must read the first column in to one array, the second column in to a second array, and then nth column in to a third array. The text file is tab and space delimited and contains around 10 000 rows of data.
My problem is that I don't know how to open the file delimited with tab and space and then read the data in to several arrays using VBA memory without writing the data to a sheet (I want to avoid this as it takes a very long time to process this much data).
Any help is greatly appreciated!