Try ["\\jtchp58544\new smd\"]

>hi ,
>thank you it works,
>but about the path
>
>i print the path i got
>\\jtchp58544\new smd\MAIN1.XLS && but nothing save inside this bath.
>any idea.
>
>

>USE main1
>gcDelimName = ALIAS() + [.XLS]
>gcDelimName = [\\jtchp58544\new smd\] + FORCEEXT(JUSTSTEM(gcDelimName),[XLS])
>COPY fields num,Msisdn,date,flag TO  (gcDelimFile) XL5
>brow
>

>thanks
>>Remove PUTFILE()
>>

>>USE main1
>>gcDelimName = ALIAS() + [.XLS]
>>gcDelimName = [\\cctfil01\hrd-spdata\SMD\Projects\Customer satisfaction Measurments\1214 Call Center Satisfaction\]+;
>>              [2005 1214 Servcie II\customer database\Treated data\] + FORCEEXT(JUSTSTEM(gcDelimName),[XLS])
>>COPY fields num,Msisdn,date,flag TO (gcDelimFile) XL5
>>

>>
>>
>>>hi,
>>>thank you,
>>>
>>>this code open screen save in llocp---> save as...etc
>>>
>>>how i can skip this step, make copy automitcly
>>>

>>>USE main1
>>>gcDelimName = ALIAS( ) + '.xls'
>>>gcDelimFile = PUTFILE('excel_file:', gcDelimName, 'xls')
>>>IF EMPTY(gcDelimFile)  && Esc pressed
>>>   CANCEL
>>>ENDIF
>>>
>>>z="\\cctfil01\hrd-spdata"
>>>gcDelimName = [z\SMD\Projects\Customer satisfaction Measurments\1214 Call Center Satisfaction\]+;
>>>              [2005 1214 Servcie II\customer database\Treated data\] + FORCEEXT(JUSTSTEM(gcDelimName),[XLS])
>>>COPY fields num,Msisdn,date,flag TO (gcDelimFile) XL5
>>>

>>>>Mohammed,
>>>>I just saw that your path is not valid:
>>>>"\\server\z:\...
>>>>It can't be that way. The path is either:
>>>>
>>>>z:\...
>>>>
>>>>either:
>>>>
>>>>\\server\drive_letter_of_shared_drive\....
>>>>
>>>>
>>>>>hi,
>>>>>thank you for reply.
>>>>>
>>>>>but i try as under and i cant see excel sheet at my server path,
>>>>>
>>>>>is there away to brows only the last operation via this code only,
>>>>>mean the previouse operation runing automaticly.
>>>>>

>>>>>&&&at command button---> click event, maybe it must be used via another events
>>>>>SET DEFAULT TO d:\llocp
>>>>>
>>>>>USE main1
>>>>>gcDelimName = ALIAS( ) + '.xls'
>>>>>gcDelimFile = PUTFILE('excel_file:', gcDelimName, 'xls')
>>>>>IF EMPTY(gcDelimFile)  && Esc pressed
>>>>>   CANCEL
>>>>>ENDIF
>>>>>
>>>>>gcDelimName = [\\server\z:\SMD\Projects\Customer satisfaction Measurments\1214 Call Center Satisfaction\]+;
>>>>>              [2005 1214 Servcie II\customer database\Treated data\] + FORCEEXT(JUSTSTEM(gcDelimName),[XLS])
>>>>>COPY fields num,Msisdn,date,flag TO (gcDelimFile) XL5
>>>>>SET DEFAULT TO "\\server\z:\SMD\Projects\Customer satisfaction Measurments\1214 Call Center Satisfaction\2005 1214 Servcie II\customer database\Treated data\"
>>>>>brow
>>>>>SET DEFAULT TO d:\llocp
>>>>>
>>>>> CLOSE all
>>>>>SET TALK OFF
>>>>>SET ECHO off
>>>>>SET SAFETY off
>>>>>
>>>>>***********************************
>>>>>SELECT 3
>>>>>USE mstr
>>>>>SET DELETED on
>>>>>append from main2
>>>>>DELETE FROM main2
>>>>>************************************
>>>>>getdir()
>>>>>thisform.text9.Value=GETFILE('xls')
>>>>>CREATE TABLE main1;
>>>>>(msisdn n(15),num n(8),date d(8) ,flag n(1) )
>>>>>APPEND FROM (thisform.text9.Value) TYPE xl5
>>>>>Replace Date  with thisform.text1.value ;
>>>>>        flag   with 0 ;
>>>>>               num with RecNo() ALL
>>>>>*************************************************
>>>>>SET DEFAULT TO d:\llocp\
>>>>>
>>>>>

>>>>>thanks
>>>>>>>hi all,
>>>>>>>i try to copy my table to excel sheet at my server , but no error message and no result
>>>>>>>

>>>>>>>USE main1
>>>>>>>gcDelimName = ALIAS( ) + '.xls'
>>>>>>>gcDelimFile = PUTFILE('excel_file:', gcDelimName, 'xls')
>>>>>>>IF EMPTY(gcDelimFile)  && Esc pressed
>>>>>>>   CANCEL
>>>>>>>ENDIF
>>>>>>>
>>>>>>>COPY fields num,Msisdn,date,flag TO "\\server\z:\SMD\Projects\Customer satisfaction Measurments\1214 Call Center Satisfaction\2005 1214 Servcie II\customer database\Treated data\   (gcDelimFile) XL5"
>>>>>>>brow
>>>>>>>SET DEFAULT TO d:\llocp
>>>>>>>

>>>>>>>thanks
>>>>>>
>>>>>>

>>>>>>USE main1
>>>>>>gcDelimName = ALIAS( ) + '.xls'
>>>>>>gcDelimFile = PUTFILE('excel_file:', gcDelimName, 'xls')
>>>>>>IF EMPTY(gcDelimFile)  && Esc pressed
>>>>>>   CANCEL
>>>>>>ENDIF
>>>>>>
>>>>>>gcDelimName = [\\server\z:\SMD\Projects\Customer satisfaction Measurments\1214 Call Center Satisfaction\]+;
>>>>>>              [2005 1214 Servcie II\customer database\Treated data\] + FORCEEXT(JUSTSTEM(gcDelimName),[XLS])
>>>>>>COPY fields num,Msisdn,date,flag TO (gcDelimFile) XL5
>>>>>>brow
>>>>>>SET DEFAULT TO d:\llocp
>>>>>>