Export txt file problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Try saving as a Comma Separated Value file (.csv)
You will have commas in the data but no quotes.
 
Use the FileFormat property xlTextWindows. It will save the text without
adding the quotes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SaveAs *.txt - Outputting with Text quantifiers 4
Error with currunc 3
Save selected cells to a Text file 6
Can you create a global variable ? 11
saving a worksheet as a .txt file with filename of specified cell 1
Error when saving as TAB TXT (euro transforms in $) 1
Excel Automation - Export Txt 4
Message box to prompt for file name upon save 2

Back
Top