Save each row as a separate .txt file

**MrZorakskeep** · 05-09-2011, 03:14 PM

Hey,

I am looking for a solution to save each row of my excel sheet as a separate .txt file at ones. I am not very familiar with macro's but I have the feeling that this is possible with a macro script.

What I have:
A B C D E F G etc
1. text1 | cow | chicken | breakfast | diner | etc..
2. text2 | cat | chicken | breakfast | dish | etc..
3. text3 | dog | chicken | breakfast | warm meal | etc..

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

As output I want to create the following:
D:\My Documents\text1.txt
cow chicken breakfast diner etc..

D:\My Documents\text2.txt
cat chicken breakfast dish

Anyone ideas?

**barryleajo** · 05-09-2011, 03:33 PM

Hi MrZorakskeep
Welcome to the forum.
The attached should get you going.
barry

**MrZorakskeep** · 05-09-2011, 03:48 PM

Hey Barryleajo! Thanks that was fast and it works great and easy!

**barryleajo** · 05-09-2011, 04:10 PM

Glad to be of assistance.
Perhaps you would mark your thread as SOLVED.
See rule 9 in the Forum Rules on how to do this

**crisstina** · 06-13-2012, 12:41 PM

Thank you! it was useful for me too!

**Accountteam12** · 02-13-2013, 02:14 PM

I have downloaded the file and copied my information to the document, however I am lost on how to save each row as an individual text file. Please help as soon as you can. Step by step instructions would help.

thanks

**DerekLee1** · 07-06-2013, 04:31 PM

Is there a way to do this so that the cells from each row are tab-delimited in the txt file instead of separated by a space? Many thanks!

**jeffreybrown** · 07-06-2013, 05:03 PM

Hi DerekLee1 & Welcome to the Forum,

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Please continue in your other thread...