Group,
Recently I found a thread to parse a data file. The guts of the
operation uses a statement called Mid. I have a data file that has
data that is comma separated and when opened manually in Excel and
converted via Text To Columns it looks fine. Using the Open command
and single stepping down to Mid I get to the end of the of the first
line I get an error message. There is a non-alphanumeric character
between the last character of the first line of data and the first
character in the second line of data. This I believe is causing all my
problems. Is there a way to skip this special character?

Tony


--
ajocius
------------------------------------------------------------------------
ajocius's Profile: http://www.excelforum.com/member.php...o&userid=17695
View this thread: http://www.excelforum.com/showthread...hreadid=544096