On Tue, 14 Aug 2007 22:53:06 -0400, Little Penny
wrote:

Ron I take my last post back. It works. The problem was i was using
CAPS on my txt file extention.

Thanks for all your help

I'm glad my suggestion was helpful. Thanks for the feedback.

By the way, please note that your example data and output should that you were
using the first 9 positions and not the first 8. And that is how I wrote the
macro.
--ron