ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Write to Output Type Formating (https://www.excelbanter.com/excel-programming/303729-write-output-type-formating.html)

Dan T[_3_]

Write to Output Type Formating
 
The write to text file command exports in CSV, is there a way to change this so it writes to Tab Delimited?

Dave Peterson[_3_]

Write to Output Type Formating
 
Maybe you can steal some code and create your own macro that does it:

Earl Kiosterud's Text Write program:
http://www.tushar-mehta.com/
Look for Text Write in the left hand frame.

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

(In fact, Earl's has a lot of options--maybe you could just run with his.)

Dan T wrote:

The write to text file command exports in CSV, is there a way to change this so it writes to Tab Delimited?


--

Dave Peterson



All times are GMT +1. The time now is 12:30 PM.

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