Macro to create txt-file with pipe seperator

[elgato74]

Hello


I would like to accomplish the following task using a macro.

1. I select a range, eg. A6187:B6188
2. I run the macro
3. It creates a txt-file with the "|" seperato - as shown in the second image
4. It saves the txt-file to a specified location


Screenshot 2017-07-26 20.46.12.png



Screenshot 2017-07-26 20.46.25.png



Thank you !!!

[Olly]

Read my blog post about writing text files from Excel here: http://excel.solutions/2014/04/using...-to-text-file/

[elgato74]

Great ! But how do I change it so only a selected range is wrote to text file ?

[Olly]

Just amend this line:

Please Login or Register  to view this content.

So if you want to base it on the selected cells, then change it to:

Please Login or Register  to view this content.

[elgato74]

that was an easy fix

Thank you !!

[Olly]

Happy to help, thanks for the feedback

[elgato74]

would you mind giving me rep as well ?

[Olly]

would you mind giving me rep as well ?

For asking a question?!

Nice try!!

[elgato74]

sorry i thought i rep works both ways. never mind. and thank you again.