View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ray Ray[_2_] Ray Ray[_2_] is offline
external usenet poster
 
Posts: 1
Default Exporting Text File

Hello all

I am writing an Excel macro for exporting worksheet data into text file.
However, both statements "PRINT #" and "WRITE #" exports text in delimited
format (i.e. Chr(13) + Chr(10) added at the end each time these statements
are used). How can I get rid of the Chr(13) + Chr(10) codes?

Thanks in advance.

Raymond Lee