Read my message again, I wrote this: gcDelimFile is changed in your program to gcDelimName, you really should be able to see that for yourself!

The other things I wrote, was to show you some samples of what you wrote wrong, and what was correct, NOT to completely fix your code.

The ole error probably comes from some error which is not in the code you have sent us, but I can not tell exactly.

Regarding stars: you, as the one who created the thread, has some buttons to click on all the answers, one for one star, and one for three stars.

>hi,
>
>thanks for you and all people help me at the GRATE UT.
>
>i try many many tims before i ask at UT, but some time i have somthing new ,
>and if i need somthing urgent at my work.
>
>about stars i think sit superviser give the stars ?
>if i have a good answer. how i can give stars ?
>
>and i try what you ask me to read it carfully,Mr Borislav Borissov
>and i include that via last message.
> i got error message &&&OLE error code 0x800300fc:unknown com status code.
>
>
>
>

>USE main1
>gcDelimName = ALIAS( ) + '.xls'
>gcPath      = [\\Jtchp58544\new smd\Training\Quality Test 01\]
>gcDelimName =  gcPath + ALIAS() + [.XLS]
>COPY fields num,Msisdn,date,flag TO (gcDelimName) XL5
>SET DEFAULT TO [\\Jtchp58544\new smd\Quality Test 01\]
>brow
>

>I ask abot this errors
>

>COPY fields num,Msisdn,date,flag TO TO (gcDelimFile) xl5 &&&Variable "gcDelimFile" is not found
>COPY fields num,Msisdn,date,flag TO ["\\Jtchp58544\new smd\Training\Quality Test 01\"] + FORCEEXT(JUSTSTEM(gcDelimName),[XLS])&&&Invalid path or file name
>COPY fields num,Msisdn,date,flag TO (gcDelimName) xl5 &&&OLE error code 0x800300fc:unknown com status code
>

>not this ..
>
>

>SET DEFAULT TO ["\\Jtchp58544\new smd\Quality Test 01\"] && wrong
>SET DEFAULT TO [\\Jtchp58544\new smd\Quality Test 01\] && correct
>SET DEFAULT TO "\\Jtchp58544\new smd\Quality Test 01\" && this is also
>

>
>thanks.
>
>>Hi Mohammad,
>>
>>no offence, but do you try to learn from your earlier errors, and do you really read all the tips you receive? At least one of your errors is caused by exactly the same error as you were tipped of yesterday, I think it was by Borislav! We are all happy to help you, but giving the same help over and over again is very frustrating, and makes some of us unwilling to help.
>>
>>gcDelimFile is changed in your program to gcDelimName, you really should be able to see that for yourself!

>>gcDelimName = ["\\Jtchp58544\new smd\Training\Quality Test 01\"] + FORCEEXT(JUSTSTEM(gcDelimName),[XLS])

>>You were told yesterday that you shall use ONE, not two delimiters!

>>gcDelimName = [\\Jtchp58544\new smd\Training\Quality Test 01\] + FORCEEXT(JUSTSTEM(gcDelimName),[XLS])

>>The same error is repeated many times in your code, here's another one

>>SET DEFAULT TO ["\\Jtchp58544\new smd\Quality Test 01\"] && wrong
>>SET DEFAULT TO [\\Jtchp58544\new smd\Quality Test 01\] && correct
>>SET DEFAULT TO "\\Jtchp58544\new smd\Quality Test 01\" && this is also correct

>>
>>One last thing: When you ask for help, and you get your problem solved, it's common to send a message about that to the person who sent you the missing pieces, and it's also common to honor him/her with stars, because then other people with similar problems can easier find the same help as you received.
>>
>>
>>>hi,
>>>thank you for reply and help,
>>>
>>>
>>>it try this code yesterday no errors,
>>>but itry it now
>>>i got error message Variable "gcDelimFile" is not found
>>>

>>>USE main1&& form d:\llocp
>>>gcDelimName = ALIAS( ) + '.xls'
>>>**gcDelimFile = PUTFILE('excel_file:', gcDelimName, 'xls')&&if active this line return to same dir d:\llocp
>>>gcPath      = [\\Jtchp58544\new smd\Training\Quality Test 01\]
>>>gcDelimName =  gcPath + ALIAS() + [.XLS]
>>>COPY fields num,Msisdn,date,flag TO (gcDelimFile) XL5
>>>SET DEFAULT TO (gcPath)
>>>brow
>>>

>>>
>>>i try anothr thing i got 3 error messages
>>>

>>>SET DEFAULT TO d:\llocp
>>>USE main1
>>>gcDelimName = ALIAS() + [.XLS]
>>>gcDelimName = ["\\Jtchp58544\new smd\Training\Quality Test 01\"] + FORCEEXT(JUSTSTEM(gcDelimName),[XLS])
>>>COPY fields num,Msisdn,date,flag TO TO (gcDelimFile) xl5 &&&Variable "gcDelimFile" is not found
>>>COPY fields num,Msisdn,date,flag TO ["\\Jtchp58544\new smd\Training\Quality Test 01\"] + FORCEEXT(JUSTSTEM(gcDelimName),[XLS])&&&Invalid path or file name
>>>COPY fields num,Msisdn,date,flag TO (gcDelimName) xl5 &&&OLE error code 0x800300fc:unknown com status code
>>>SET DEFAULT TO ["\\Jtchp58544\new smd\Quality Test 01\"]
>>>brow
>>>SET DEFAULT TO d:\llocp
>>>

>>>thanks
>>>>>hi,
>>>>>sorry to repeat it again.
>>>>>why i cant see it at the path,
>>>>>

>>>>>USE main1
>>>>>gcDelimName = ALIAS() + [.XLS]
>>>>>gcDelimName = ["\\Jtchp58544\new smd\Training\Quality Test 01\"] + FORCEEXT(JUSTSTEM(gcDelimName),[XLS])
>>>>>COPY fields num,Msisdn,date,flag TO (gcDelimFile) XL5
>>>>>SET DEFAULT TO ["\\Jtchp58544\new smd\Quality Test 01\"]
>>>>>brow
>>>>>
>>>>>

>>>>
>>>>Such an open ended question as thread title............
>>>>
>>>>
>>>>At any rate..........
>>>>
>>>>What happened to the "Training" piece of the path in gcDelimName when you did you SET DEFAULT???