i wish but...
any way, how much i must bay for some one like you
>Hi Mohammed.
>
>You don't seem to be understanding very much of Foxpro. Alex included main1 so you can see main1 must be open. You said you create it everytime. So create it before trying the rest of the code. Do not expect anyone is giving you all the answer for free.
>
>If you want someone to do your job for you, pay them!
>
>
>
>>hi,
>>i try as under, error message Object "main1" is not found
>>
>>USE main1
>>main1.date = STRTRAN(main1.date, "/", "_")
>>
>>gcDelimName = ALIAS() + '.xls'
>>gcPath = [c:\]
>>gcDelimName = gcPath + DTOS((date)) + ".XLS"
>>COPY fields no,date TO (gcDelimName) XL5
>>
>>
>>>
thank you both,
>>>>but i think i see excel sheet as 02-02-2006.xls . or 02_02_2006.xls>>>
>>>If what you want is 02/02/2006.xls, you know you cannot do that.
>>>If what you are saying now is that you want 02-02-2006.xls or 02_02_2006.xls then make it so.
>>>
>>>Change the slash in the filename to an underscore:
>>>
>>>gcFilename = STRTRAN(gcFileName, "/", "_")
>>>