ASCII File input# problem w/ commas

[Garratt]

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:

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.

[techgnome]

Try Line Input instead.,...

TG

[Garratt]

Wow... I had no idea. For "Input", "Line Input" doesn't show up as a related topic in the help file.

Poop - egg on my face.


Thanks man