M
Mac Lingo
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
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