Excel formula - OLE error

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Excel formula - OLE error

Message

From

21/09/2012 06:08:55

All

General information

Forum:

Visual FoxPro

Category:

COM/DCOM and OLE Automation

Title:

Excel formula - OLE error

Environment versions

Visual FoxPro:

VFP 9 SP2

OS:

Windows XP SP2

Network:

Windows XP

Database:

Visual FoxPro

Miscellaneous

Thread ID:

01553379

Message ID:

01553379

Views:

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.