I'm using Excel VBA to read some big ASCII/Text files.

I've run into a problem and finally figured out that when I'm INPUTing lines in from the text file, lines with commas in them are broken up.

example line:

"asdfa 23 asdf asdf,xcvzxc"

gets read as two separate lines and the comma disappears:

"asdfa 23 asdf asdf"
"xcvzxc"


I'm reading the lines into an array like this:
Code:
Dim MyArray() as String

X = 0
Do While not EOF(1)
X = X + 1
ReDim Preserve MyArray(X)
Input #1, MyArray(X)
Loop

Uggg... Help me.