View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Greshter Greshter is offline
external usenet poster
 
Posts: 6
Default Export a text file from each row of a spreadsheet

Hi,

I'm sure this has been done before and is in other threads but I thought I'd ask. I have a series of rows that I need to export as individual text files i.e. one row would produce one text file. There are 7 columns with the first column being the file name. Columns 2 - 7 would be the input lines in the text file - and ideally there would be one line per column.

I.e. A B C D E F G
A1 0.1 0 0 -0.1 114 116
B1 0.1 0 0 -0.1 114 117
C1 0.1 0 0 -0.1 114 115

First text file would be named "A1" and would have the following text in it:

0.1
0
0
-0.1
114
116

Second file would be "B1" and so on ...

If anybody has some good ideas about this one it would be great to get some feedback.

Thanks,
Mike