Hi Erik,
>>I would like to call the Excel SubTotal method thru a VFP ActiveX Automation call.
>>
>>I understand how to pass all the parameters the method is looking for except one that is an array of the column numbers to subtotal on.
>>
>>Can anyone suggest how to pass arrays from VFP to Excel that I can use for this purpose?
>>
>>Thanks!
>
>Does not passing the array by reference work?
>
>exPression.SubTotal(nGroupBy, nFunction, @laTotalList)
Well, I get an OLE error when I tried that:
DIMENSION laArray[1]
laArray[1] = 14
loSheet.ActiveSheet.Subtotal(5, xlsum, @laArray, 1, 0, 1)
Can you see anything wrong with that?
Thanks!
Vern