Better method for reading really large text files into an array using VBA

[welchs101]

Hi,

I have a situation where i have a text input file. The file has approximately 1.3million rows in it. I know excel can't handle this many rows (and i dont want to read it in with excel) so i am reading in the file using vba and storing the result into an array.

Below is the code i am using:

Please Login or Register  to view this content.

When i run this code it takes like A LONG TIME to just read in the text file.

Does anyone have any suggestions on how to speed this up?

[cytop]

EDITED - This topic is already being discussed in http://www.excelforum.com/excel-prog...using-vba.html

[welchs101]

while it could be said that the other post should address this issue.......my original post at the link you posted was NOT for this specific issue...at all. but i will leave it up to you guys to decide where things go.

[welchs101]

the more i think about it .......the more i am convinced this post is "different" than the other one.......how can i prove this......simply........no one in the other post suggested "fixes" for large text files.