Targeted column each cell save as a separate .txt file (Western European text format)

Hey,

I am looking for a solution to save targeted column each cell of my excel sheet as a separate .txt file (Western European text format [windows-1252]) at ones.

What I have:

Name Bonus Right
1. ABBANK | 10% | 1:R1 |
2. FAS | 20% | n/a | .
3. BDFINANCE | 35% | 2:R1 | etc..

In this case the name of the text file (e.g. ABBANK.txt) and all the other Column cell contain the information with column heading, I would like to see in the text file.

D:\My Documents\ABBANK.txt
Bonus : 10%
Right : 1:R1.

D:\My Documents\FAS.txt
Bonus : 20%
Right : n/a
etc.....

Anyone ideas? please help me.

Many Many Thanks. It works