Write each line to text file

[jeffttu]

I have a spreadsheet of x,y coordinates and unique IDs. I need each line to written to its own text file.

I'm not a programmer but I am a pretty good at copy, paste and tweak. Any guidance would be greatly appreciated!

 

[wolverineb]

Welcome.

Check these out and see if it is what you're looking for. Maybe you'd have to add some sort of looping mechanism.

http://www.cpearson.com/excel/ImpText.aspx

http://zo-d.com/blog/archives/programming/vba-writing-to-a-text-file-ms-project-excel.html