Rahul,

The common practice is to record a macro in Excel and then translate the macro VBA code to VFP.

Here is how you could merge cells:

#include msconstants.h
oExcel=getobject(,"Excel.Application")  &&get reference to already open file

oExcel.Activesheet.Range("a8:D10").Select
    With oExcel.Selection
        .HorizontalAlignment = xlCenter
        .VerticalAlignment = xlJustify
        .WrapText = .t.
        .Orientation = 0
        .ShrinkToFit = .f.
        .MergeCells = .t.
    EndWith
oExcel=.null.

>Dear Sir/Madam
>
>I am trying to merge Cells of Excel Sheet through VFP5 Commands.
>
>Please give me the syntax to do so.
>
>If you can advise any Help file which has VFP5 syntax for MsOffice. Please
>suggest.
>
>Thanks in Advance
>
>Rahul