>I'm trying to convert an Excel macro for calculating subtotals to VFP. The VB syntax is :
>
>Selection.SubTotal GroupBy:=3, Function:=xlSum, TotalList:=array(11,12) Replace:=True, PageBreaks:=False, SummaryBelowData:=True
>
>
>My VFP syntax, which isn't working, is:
>
>.selection.subtotal(3,-4157,laList,.t.,.f.,.t.)
>
>
>Any suggestions?
Michael,
Apart from excel being very slow in subtotaling there you say subtotal fields 11,12. An array in Excel is an array just like in VFP. That's you create an array and pass by reference :
dimension laList[2]
laList[1]=11
laList[1]=12
.selection.subtotal(3,-4157,@laList,.t.,.f.,.t.)
PS:If possible use pivot instead. It's fast.
Cetin