Export a range of data in excel to ascii plain text formatted table csv or txt file using vba

Question

I need to export only a range of data from Excel or LibreOffice Calc file to ascii plain text table - text file. The output should be in the format as follows :

+--------+--------------+--------+
| Name   | Place        | Phone  |
+========+==============+========+
| JOHN   | TEXAS        | 123456 |
+--------+--------------+--------+
| ROBERT | INDIANAPOLIS | 234567 |
+--------+--------------+--------+
| JEANNE | CAMBODIA     | 345678 |
+--------+--------------+--------+
| ANN    | CANADA       | 456789 |
+--------+--------------+--------+
| RICK   | HAGUE        | 567890 |
+--------+--------------+--------+

Is it possible using vba ? And yes, the numbers should be Right aligned.

Or like this :

+--------+--------------+--------+
| Name   | Place        | Phone  |
+========+==============+========+
| JOHN   | TEXAS        | 123456 |
| ROBERT | INDIANAPOLIS | 234567 |
| JEANNE | CAMBODIA     | 345678 |
| ANN    | CANADA       | 456789 |
| RICK   | HAGUE        | 567890 |
+--------+--------------+--------+

Answer 1

If I'm not mistaken, a plain text file won't justify a column at all.

That said, give this a try: http://www.excel-easy.com/vba/examples/write-data-to-text-file.html