I'm trying to pull some text out of a lengthy excel document to do some text
mining on. I'd like to have a macro (or another solution that would work) to
pull the headers out of each line (record) and save each line as a text file.
Any help would be greatly appreciated!
Thanks

So, if I had an excel (.csv file) file that captured email content (someone
in the past did this manually) like this:

Subject,Body,Date
Lunch Plans,Do you have lunch plans?,4/5/2006
What's Up?,What are you up to today?,4/5/2006

Would be converted to 2 .txt files like this:

Text File 1:
Subject:
Lunch Plans

Body:
Do you have Lunch Plans?

Date:
4/5/2006

Text File 2:
Subject:
What's Up?

Body:
What are you up to today?

Date:
4/5/2006