save file as txt - why do I get gibberish?

[SandsB]

I'm doing my file save like this:
ActiveWorkbook.SaveAs Filename:="C:\MyFile.txt"
and I get all kinds of stuff I don't want to see. It looks like Excel is saving my file as an xls that just happens to have a txt file extension. Can someone tell me (a VBA idiot) how to do this save in txt format?

Thanks

 

[SandsB]

Nevermind. Got it:
ActiveWorkbook.SaveAs Filename:= _
"C:\MyFile.txt", _
FileFormat:=xlText, CreateBackup:=False