How can I save each row of a spreadsheet as separate text files?

[maxim545]

I would really really appreciate some help here!!
I have a spreadsheet with >4000 rows, where each row has 2 columns. I want to save each row as a separate text file. How can I do that?
An example of the structure of the data:

ID (number) Report (text)
1645 Today is a beautiful day...
1967 Today the sun is shinning
2389 Today is a rainy day...

I need separate txt files containing each report and hopefully each file under the name of the respective ID.

[FDibbins]

Please do not post duplicate threads - I have closed the other 2

[Logit]

.
https://superuser.com/questions/3871...ther-cell-data

[maxim545]

Sorry for the multiple threads, I am a new member here.
Thanks for the link.
Unfortunately, that didn't work.

[Logit]

.

Please Login or Register  to view this content.

[maxim545]

Thank you so much!!
What would I have to change if I want the content of the file to be only the second column? (i.e. the first column is used just for the file names)

is it:
fileOut.write Cells(i, 2)

instead of:
fileOut.write Cells(i, 1) & " " & Cells(i, 2)

???

[Logit]

.
Change : fileOut.write Cells(i, 1) & " " & Cells(i, 2)

To: fileOut.write Cells(i, 2)

[maxim545]

)
Thank you very much!!!