View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
buster buster is offline
external usenet poster
 
Posts: 7
Default Export txt file problem

Use the FileFormat property xlTextWindows. It will save the text without
adding the quotes.

"Oscar" wrote:

When I export txt file (ActiveWorkbook.SaveAs FileName:="Result.txt",
FileFormat:=xlText) quotes appear in txt file:
"Cell A1 Cell A2 ... Cell An"

How can I get txt file without quotes:
Cell A1 Cell A2 ... Cell An

Regards,
Oscar.