Merge cell in excel - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Merge cell in excel

Message

From

04/07/2007 12:38:09

04/07/2007 08:52:20

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:

01237729

Message ID:

01237766

Views:

>oExcel = CREATEOBJECT([Excel.Application])
>oExcel.Visible = .t.
>oExcel.Workbooks.Add()
>oExcel.Range("A1:H1").Select
>oExcel.Selection.Merge()
>

Or even shorter

oExcel.Range("A1:H1").Merge()

--sb--