This is the bizarre thing, for certain lines it's okay (every 4th - specifc
format) but the others no. I had already used the code you've suggested,
bizarre.



"Jim Rech" wrote:

When I save a file with this code I do not get quotes:

ActiveWorkbook.SaveAs "abc", xlTextMSDOS

--
Jim Rech
Excel MVP
"MaxFrance" wrote in message
...
| If I save (using a macro) an excel file as a text file MSDOS (not tab
| delimited), I get a file with quotation marks at the start and end of each
| line! If I do the process manually the file is perfect. Can someone help
!!
|
| Excel 2000 all updates done
| XP prof all updates done (with sp2)
|
| Thanks