Larry,

I have a weakness for text file manipulation--it's been my pleasure!

Regards,
Shockley



"L Mehl" wrote in message
...
Shockley --

Thank you. You are very generous to help me so completely.

Larry


"shockley" wrote in message
...
Larry,

I will probably use it after I write some code to strip the Y-values
before the import<

Replace the line

If tsRead.AtEndOfStream Then Exit Do

with this line

If sTest = " " Then Exit Do

This will stop the parsing at the line with the single space--no need to
strip the y-values. I was testing the macro on a souce file with no
y-values
and then forgot to revise it back to work with the real-life format of
the
file.

I'll be glad to help with any more bugs.

Regards,
Shockley



"L Mehl" wrote in message
...
Shockley --

I will probably use it after I write some code to strip the Y-values
before
the import, to save perhaps more time.

Larry
"shockley" wrote in message
...
...


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.600 / Virus Database: 381 - Release Date: 2/28/2004