ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Export as pipe separated (https://www.excelbanter.com/excel-discussion-misc-queries/147207-export-pipe-separated.html)

Sashi[_2_]

Export as pipe separated
 
All,

How do I export my Excel as a pipe separated text file?

I'm not familiar with VBScript so if you're going to post such a
solution, please include a how-to so I know how to incorporate it into
my spreadsheet and run it.

Thanks in advance,
Sashi


Peo Sjoblom

Export as pipe separated
 

http://www.mcgimpsey.com/excel/textfiles.html


http://www.mvps.org/dmcritchie/excel/getstarted.htm


the latter explains how to "install" macros

--
Regards,

Peo Sjoblom



"Sashi" wrote in message
oups.com...
All,

How do I export my Excel as a pipe separated text file?

I'm not familiar with VBScript so if you're going to post such a
solution, please include a how-to so I know how to incorporate it into
my spreadsheet and run it.

Thanks in advance,
Sashi




Sashi[_2_]

Export as pipe separated
 
On Jun 20, 10:51 am, "Peo Sjoblom" wrote:
http://www.mcgimpsey.com/excel/textfiles.html

http://www.mvps.org/dmcritchie/excel/getstarted.htm

the latter explains how to "install" macros

--
Regards,

Peo Sjoblom

"Sashi" wrote in message

oups.com...

All,


How do I export my Excel as a pipe separated text file?


I'm not familiar with VBScript so if you're going to post such a
solution, please include a how-to so I know how to incorporate it into
my spreadsheet and run it.


Thanks in advance,
Sashi


Peo, thanks for your help.
Sashi



All times are GMT +1. The time now is 12:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com