>Hi,
>
>How to convert the EXCEL VBA code of the subtotal and groupby to VFP9 ?
>
> Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(3), Replace:=True, PageBreaks:=False, SummaryBelowData:=True
>
>
>
>Please advise.
>
>Thanks.
Open the VBA editor in Excel.
Mark Subtotal and press F1.
That will open Excel VBA help and you will see the positioned parameters, and will see how you could use this method in VFP.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.