VBA - Error Using Mid To Parse A Data (.dat) File
 

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

VBA - Error Using Mid To Parse A Data (.dat) File
 

Mid should have no problem with any special characters.

Possibly the error is unrelated to MID. After the error, in the VBE, go to
Tools=References and see if you see a reference marked as MISSING. If so,
this is probably the source of the problem. You need to clear up this
missing reference.

You can also try using

VBA.Mid

if you want a band aid approach.

--
regards,
Tom Ogilvy

"ajocius" wrote in
message ...

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

VBA - Error Using Mid To Parse A Data (.dat) File
 

Tom,
A million thanks. That was the problem, a logical problem. NextPos
wasn't resetting and I reset Pos and all is fine. Awesome. One I
realized it was a logic problem and single stepped into the problem, it
was as obvious as a semi-truck hitting a Yugo. Thanks again for your
help.

Tony


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