> Cetin,
> First,
>

TEXT TO myText noshow 

> is not supported in VFP6
> second, it is something like this
>

> lcFname = Sys(2023)+'\'+Sys(2015)+'.txt'
> SET Textmerge To (m.lcFname) Noshow
> SET Textmerge On
> TEXT 
> "0001","VFP7",01/01/2002,"skipme",30/01/2003,001
> "0002","VFP8",01/31/2003,"skipme",29/02/2000,002
> "0002","C#",01/31/2003,"skipme",29/02/2000,002
> EndText

> Third is, without specify column range it will be an eror i.e.
>

> .Application.Selection.TextToColumns(.Range('A1'), xlDelimited, ;
> 

> instead of
> i.e.

>     .Columns("A:A").Select	
>    .Application.Selection.TextToColumns(.Range('A1'), xlDelimited, ;
> 

>
> regards
> Subhankar

Subhankar,
do yourself a favor,
do not teach Cetin with MS Office automation, he forget about it more that we both will ever know.
Believe me, he DID test his code before posting it, unlike me :-)
About VFP6,
It is time to upgrade :-)
Believe me only the report enhancements worth every cent you spent (that is of course if you didn't decide to switch to other platform)


-----------------
Borislav Borissov

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.