Hi,

I have recorded a macro to store an Excel workbook as a .* txt file.
The result from the macro-recorder is mentioned below

---------------------------------------------------------------------------------
ActiveWorkbook. SaveAs Filename:="C:\Temp\map1.txt", _
FileFormat:=xlTextMSDOS, CreateBackup:=False
---------------------------------------------------------------------------------

If I carry out above action manually the text is taken over exactly the same
as in the workbook,
however if I carry out the action by using the above a macro, some data with
"quotations mark" ("") are stored in the text file.
This only occurs for cells which contains data with a comma:

For example Cell M reads in Excel: NHAVA SHEVA, INDIA but in the text file
"NHAVA SHEVA, INDIA"

Sounds familiar?
How do I have to write my macro that the "quotations mark" will not be
shown?

Thanks in advance,
Mischa

Ps. I am using Excel 2000.