>>How about:
>>

>>use NAN in 0
>>Select NAN
>>liRecc=RECC()
>>APPEND FROM aar TYPE xls FOR RECN()>liRecc+6
>>

>>
>>>hi,
>>>thank you,
>>>
>>>i try as under but nothing happend
>>>USE nan
>>>liRecc=RECC()
>>>APPEND FROM aar TYPE xls FOR RECN()>liRecc+6
>>>
>>>thanks.
>>>m.qasem
>
>Hi Terry,
>
>Would you agree with me that the for clause does not do what the author meant it to do ?

Hi Gregory

I should imagine that the for clause would hold no sway over the excel cells/rows/cols. As far as I know/knew, scopes only apply to FP tables and, as such, can't "pre-select" from an input source. I was surprised when I first saw

APPEND FROM aar TYPE xls FOR RECN()>liRecc+6

and thought "Oh, I didn't know you could do that". I kept schtum in my (perceived) ignorance.

Well, as it doesn't seem to work, but does without the scope, then i expect you're right.

I would go for the append (ALL) option then delete the excess records. The user will be none the wiser that this less elegant approach is being used.

Terry