View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Export Rows individuall to a new file?

Hello all, I have an excel sheet that has lets say 10 rows that look
like this:

1 My information, etc, etc..
2 My information, etc, etc..
3 My information, etc, etc..

and so on.

Is there a macro or script or anything I can use that would take each
INDIVIDUAL row and export it to a new text file? So for a document
that had 10 rows it would make 10 text files with whatever information
was in it.

Thank you!!!