Hi,
I'm hoping someone can give me a hints into the right direction on this.
I am trying to export data from one of my excel sheet into a text file.
when I use code below
ActiveWorkbook.SaveAs "C:\Data" & i1 & ".txt", xlCSV

which save data as a text file but I am getting extra doulbe quote before and after (i.e "`P`," "2," "02-MAY-07 ," "02-MAY-07 ," "`STAT`,")
But I want see something like (i.e `P`, 2, 02-MAY-07, 02-MAY-07 , `STAT`)
I am using formula/function [i.e =IF(NOT(ISBLANK(JE_Input!$A2 )),"`P`,","")] to format data from one sheet to another.
Let me know your thought what is the best way to do this.

Thanks in advance...

When you save as CSV it automatically puts in quotes around strings. It sounds like you're having the quotes with a comma appear in the actual cell. In other words, don't preformat the data. Have the sheet you want to save into CSV active and it should work.