xlAverage is -4106. You can use VFP's Object Browser to find constant values for Excel COM object.
>Hi all -
>
>Referencing
http://support.microsoft.com/default.aspx?scid=kb;en-us;265731 I was able to do exactly what I wanted to do with an Excel file.. well almost. That Microsoft article shows how to use automation to create a subtotal, eventually using:
>
>oSelected.Subtotal(1, xlsum, @laArray, .T., .F., .T.)
>
>where xlSUM was #DEFINEd as -4157.
>
>This is great, but I want to use the AVERAGE function. So it seems I need to find where I can see all the function names (is it oSelected.Average()? and all the values for the second argument (which I assume may or not be the second argument depending on the function). I looked in the Visual Basic macro editor help (based on a posting here), and that helped, but I didn't find what I think I need.
>
>Where should I be looking??
>
>Thanks!
- Jayesh