ASCII File input# problem w/ commas
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.
