Export each row as text file using first cell in row as title

[aaronmb]

Hello, Excel Forum!

I posted a question in an old forum and was kindly instructed that I was in violation of the forum rules, so I am now creating a new thread with a more concise question.

I have a .CSV file with two text columns; one serving as a title and the other as a body paragraph. For example:

_A_________ B__________
1 Title______ Content__________
2 Red______ This is a sentence...
3 Orange____And another sentence...
4 Yellow____ Yet another...
5 Green_____You get the idea...

I am hoping there is a way to save each of the rows in the worksheet as a separate document, preferably a .txt file but a Word .doc or .rtf would be fine, and use the text from the first column to title the file and the text from the second column to populate the content of the document. I'm not very familiar with VisualBasic or macros but would be willing to learn if pointed in the right direction. Any help is greatly appreciated.

Thanks

-Aaron