Need help saving as tab-delimited file

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!
 
T

Tom Ogilvy

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
Japanese text lost when save as tab delimited text file 0
Import a comma delimited file & match records 3
GetSaveAsFilename 2
SaveAs method 1
Save As xls to text (tab delimited) in encoding utf-8 0
Converting Tab Delimited Text File to A Comma Delimited Text File 1
Best way to format a flat file that Excel will load properly? 8

Top