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!