Import from Excel sheet to a text file
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...