I am trying to write out from a VBA program a worksheet as a text file. I
have code that use to work, but now doesn't.
Also, when I try to write out the worksheet using <File,<Save As a text
file, it works fine. ; no "Read-only" error.

Here's the code:
ActiveWorkbook.SaveAs _
FileName:=TS, _ ' where TS is a valid path/file name
FileFormat:=xlText, _
CreateBackup:=False, _
ReadOnlyRecommended:=False
Any ideas why the VBA code doesn't work?
Mac

Try: FileFormat:=xlTextMac
(it sounds like the appropriate one)
--
Jim Cone
Portland, Oregon USA



"Mac Lingo"

wrote in message
I am trying to write out from a VBA program a worksheet as a text file. I
have code that use to work, but now doesn't.
Also, when I try to write out the worksheet using <File,<Save As a text
file, it works fine. ; no "Read-only" error.

Here's the code:
ActiveWorkbook.SaveAs _
FileName:=TS, _ ' where TS is a valid path/file name
FileFormat:=xlText, _
CreateBackup:=False, _
ReadOnlyRecommended:=False
Any ideas why the VBA code doesn't work?
Mac