Save as Tab delimited TXT

[CaptainCsaba]

Hey!
I just have a quick question. I have a really short code to save the current file with the sheet name and an added word to it a a text file. It is a regular text file not a "tab delimited one". How can I save it as a tab delimited one?

 ActiveWorkbook.SaveAs (ActiveSheet.Name & " Done" & ".txt")

Thanks for the help!

 

[Joe4]

The Macro recorder will give you the code that you need.
Just turn it on, and save the file as the "Text (Tab delimited)" option.

So it should look something like this:

ActiveWorkbook.SaveAs ActiveSheet.Name & " Done.txt", _ 
    [COLOR=#ff0000]FileFormat:=xlText[/COLOR], CreateBackup:=False