Need help saving as tab-delimited file

  • Thread starter Thread starter monica
  • Start date Start date
M

monica

I have been saving a worksheet in my Excel file as comma-
delimited using VBA like this:

ThisWorkbook.SaveAs "FileName", xlCSVWindows

How do I save as tab-delimited text file instead? Isn't
there something to put in place of "xlCSVWindows"?

Thanks in advance!
 
An easy way to find out is to turn on the macro recorder and do you save

ActiveWorkbook.SaveAs Filename:="F:\AAAAA\Book4.txt", _
FileFormat:=xlText, _
CreateBackup:=False

so the answer is xlText
 

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

Exporting from Excel 2
Odd behavior with SaveAs 3
Saving File 3
HELP! saving as xls in current folder 1
Import a comma delimited file & match records 3
SaveAs method 1
Save As xls to text (tab delimited) in encoding utf-8 0
Best way to format a flat file that Excel will load properly? 8

Back
Top