Help with SaveAs

  • Thread starter Thread starter Glen Mettler
  • Start date Start date
G

Glen Mettler

I need to save and xls file as a tab delimited text file
This is my code:
ActiveWorkbook.SaveAs Filename:=filetosave, FileFormat:=xlText

is the default delimiter a tab or do I need to add another parameter?

Glen
 
The default for xlText is a Tab, so you do not need another parameter. Try
it and take a peek at the file using a wordprocessor.
 

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
Saving as Sheet as a Tab Delimited Text file 2
MACRO to Approve or Decline 2
Save Macro with date in name 1
Error with currunc 3
SaveAs text file from VBA Getting Error 1
Excel Automation - Export Txt 4
xlsm SaveAs xls 4

Back
Top