thank you,
>>hi all,
>>
>>i need to convert table or cursor to excel sheet to m.a=finance&& sheet name
>>

>>SELECT  question1 as ÇáÓÄÇá,question,ROUND(countof1,0) as ÖÚíÝ ,ROUND(countof2,0) as ãÞÈæá, ROUND(countof3,0) as ÌíÏ, ROUND(countof4,0) as ÌíÏÌÏÇ,ROUND(countof5,0) as ããÊÇÒ;
>> FROM  mucur INTO CURSOR koko nofilter;
>>
>>COPY TO ("c:\dept\koko as m.a) XLS &&rong statment  
>>

>>
>>thanks
>
>Mohammed,
>
>1. Check COPY TO command syntax in Help.
>
>

>COPY TO ("c:\dept\koko") TYPE XL5

>
>2. Once you created the Excel file you can open it with automation and name the Sheet any way you want.
>

>*-- Create Ole Automation with Excel
>	loExcel = createobject("Excel.Application")
>*-- Open XLS File
>	loExcel.application.WorkBooks.open("c:\dept\koko.XLS")
>
>	loExcel.DisplayAlerts = .f.
>
>           loExcel.application.application.WorkBooks(1).Sheets(1).Name = 'My Custom Name'
>          loExcel.save()
>