View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_4_] Dick Kusleika[_4_] is offline
external usenet poster
 
Posts: 595
Default saving an excel file as an ASCII text file without delimiters

Scott:

You can create your own via VBA similar to this:

http://www.dicks-blog.com/archives/2...-your-own-csv/

This shows how to create a CSV, but you can change the code to create
whatever field, delimeters you want.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Sewellst wrote:
I am new to this group, so have some patience with my stupidity
regarding Excel. I have read much about converting Excel files to
other formats, but can't seem to find the answer I'm looking for. ?
- How (or is it possible) to save an Excel data file as an ASCII text
file without any delimiters at all. I.E. I want my Excel data file
to be represented as a pure text file with rows to be
continuous/contiguous data fields and the row ending with a carriage
return/line feed.

Thank you for your time and help,
Scott Sewell
Texas Higher Education Coordinating Board