Thread: Select delimiter in .txt creation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Select delimiter in .txt creation
Chip Pearson has written code that allows you to write a text file (csv
style) and specify the delimiter.

http://www.cpearson.com/excel/imptext.htm

--
Regards,
Tom Ogilvy


"Chartsmalm" wrote in message
...
I need to send an Excel file to a system that expects text with ASCII 124
['|'] as the delimite. Can the delimiter be changed from the tav in excel.
I passing thru Access, where one has control of the delimiter, but Access
made to many changes to the formatting of my data.


Reply With QuoteReply With Quote