I have about 200 rows of text that need to export to separate text files from excel. I was wondering if anyone knew of a way this would be possible? for some reason when i create a macro to open a new excel file, paste one row and save as a text file, everything shows up with "quotes" around them. also is it possible to have the file name change it self to 1.txt, 2.txt.3.txt for example each time?

Any help/ideas would be appreciated.

Thanks!