SaveAs for tab delimited text file

[Mark]

Hi,

I'm trying to use SaveAs to save an excel worksheet as a tab delimited text file. I'm calling:

ws.SaveAs "c:\test.txt", FileFormat=xlTextWindows

The file is saved, but the format of it is just random characters inside the text file. It does not convert it to a clean txt file as it does when I do it through the excel IDE. Am I forgetting something or calling something wrong? Thanks.

Mark

 

[BrianB]

Try :-

FileFormat:=xlTex

 

[Mark]

Thanks, but that didn't work. I've tried almost all xl* options that are text files and they all produce the unreadable characters. Has anyone else gotten it to work for them?

Mark