Excel automation - formula

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Excel automation - formula

Message

From

06/07/2007 13:59:36

06/07/2007 13:53:11

General information

Forum:

Visual FoxPro

Category:

COM/DCOM and OLE Automation

Title:

Environment versions

Visual FoxPro:

VFP 9 SP1

OS:

Windows XP SP2

Network:

Windows 2003 Server

Database:

Visual FoxPro

Miscellaneous

Thread ID:

01238295

Message ID:

01238300

Views:

Hi Tamas,

oExcel.ActiveSheet.Range("K22").Formula = "=SUM(K19;K16;K10;K7)"

MartinaJ

>I tried the command line below borrowed from "Ms Office Automation with VFP" but it wont work. Got OLE error message.
>Any help?
>

>oExcel.ActiveSheet.Range("K:22").Formula = "=SUM(K19;K16;K10;K7)"
>

"Navision is evil that needs to be erazed... to the ground"

Jabber: gorila@dione.zcu.cz
Jabber? Jabbim