Hi,

How could I convert/save an excel file into a text file using macro.

Data in my Excel file has 40 to 50 rows and 15 to 20 columns.

Like below

`P` 2 02-MAY-07 02-MAY-07 `USD` -1 `A`
`P` 2 02-MAY-07 02-MAY-07 `USD` -1 `A`
`P` 2 02-MAY-07 02-MAY-07 `USD` -1 `A`

I like put a comma after each cell except last one of each row and and save the data into a text file.

`P`, 2, 02-MAY-07, 02-MAY-07, `USD`, -1, `A`
`P` 2, 02-MAY-07, 02-MAY-07, `USD`, -1, `A`
`P` 2, 25-JUL-07, 25-JUL-07, `USD`, -1, `A`

Thanks for your valuable time.

The easist way to do things like this, is to select 'Record a New Macro' from the tools menu, and then perform the task.

In this case, I just did a Save As, and selected CSV (MS-DOS) as the file type.

The code which it generated for the Macro was:

    ChDir "C:\Documents and Settings\mmackrory\Desktop"
    ActiveWorkbook.SaveAs Filename:= _
        "C:\Documents and Settings\user\Desktop\Training.csv", FileFormat:= _
        xlCSVMSDOS, CreateBackup:=False

Hope that helps,

Mike

Mike
EchoVue.com

Thanks Mike,
That works great.
But I am looking just straight text (MS-dos) format.
I don't want automatically put comma (,) by system which actually
.CSV does.

Let me know if you have any other thought.

Mike,
that works fine when I use
FileFormat:= xlMSDOS,

thanks