Save each row as a separate .txt file

Hey,

I am looking for a solution to save each row of my excel sheet as a separate .txt file at ones.

What I have:

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

In this case row A is the name of the text file (e.g. ABBANK.txt) and all the other rows contain the information I would like to see in the text file.

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

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

Anyone ideas?

monsur2009,

Give the following a try:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

tigeravatar,
Thanks for response, But show runtime error '1004' Method 'Saveas' of _worksheet failed

Code ran fine for me on a test environment with no errors. The .txt files were created as intended successfully. I'm not sure where the disconnect is for you

Thanks a Lot .. It works, But I want .txt (Windows-1252 :Western European) file and Column Heading Like as -

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


Result :

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

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