hi,
thank you for reply,

my customer need to convert any report to excel sheet via command button , as new VB accounting system have option to convert any report to excel sheet.
thanks.

>You can use COPY TO, of course, but that doesn't really give you much options. You have much more options, for an Excel report, if you use Automation. See my introductory article about Excel Automation.
>
>>hi all,
>>
>>any way to convert myreport to excel sheet ,
>>as
>>report form myreport to excel sheet, or replace all created fileds at my report to new temporary table or cursor, and change it to excle sheet via
>>

>>ex..
>>report form myreport to (newtable or cursor)
>>**********
>>use (newtable or cursore)
>>gcDelimName = ALIAS( ) + '.xls'
>>gcDelimFile = PUTFILE('excel_file:', gcDelimName, 'xls')
>>IF EMPTY(gcDelimFile)
>>   CANCEL
>>ENDIF
>>COPY TO (gcDelimFile) XL5
>>

>>thanks