Excel formula - OLE error

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Excel formula - OLE error

Message

21/09/2012 06:08:55

Tous

Information générale

Forum:

Visual FoxPro

Catégorie:

COM/DCOM et OLE Automation

Titre:

Excel formula - OLE error

Versions des environnements

Visual FoxPro:

VFP 9 SP2

OS:

Windows XP SP2

Network:

Windows XP

Database:

Visual FoxPro

Divers

Thread ID:

01553379

Message ID:

01553379

Vues:

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.