>>I try to use this formula for exporting data to MS excel but I get an Ole error(OLE error code 0x800a03ec: Unknown COM Status code.
>>

>>"=HA(N" + ALLTRIM(STR(RECNO()+1))+ "=SZUM(Y" +ALLTRIM(STR(RECNO()+1))
>>

>>
>>But If I leave out the 4. bracket ,"(", it works...
>>

>>"=HA(N" + ALLTRIM(STR(RECNO()+1))+ "=SZUMY" +ALLTRIM(STR(RECNO()+1))
>>

>>
>>Any help would be appreciated
>>
>>T.
>
>Are you sure there is such expression in Excel:
>

>=HA(N1=SZUM(Y1
>

>
>You missed several closing brackets here.

Here's the whole expression:

"=HA(N" + ALLTRIM(STR(RECNO()+1))+ "=SZUM(Y" +ALLTRIM(STR(RECNO()+1))+;
 ":AE"+ ALLTRIM(STR(RECNO()+1))+ ");"+'"'+"OK"+'"'+";"+'"'+"Nem OK"+'"'+")"

It gives the result of this:

=HA(N1=SZUM(Y1:AE1);"OK";"NemOK"), 

But I get the error...