SaveAs for tab delimited text file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top