Hello.
I'm automating Excel 2010. I have a Querytable and I want to select the entire data field.
The macro recorder gives me this VBA:

    Range("tVentas[[#Headers],[#Data],[valor_neto]]").Select

translated into VFP as

oExcel.Range("tVentas[[#Headers],[#Data],[valor_neto]]").Select

Wich gives a COM error.

oddly enought,

oExcel.Range("tVentas").Select

selects correctly the entire table. Also does tventas.ResultRange.Select, and so on

Any help?

Thanks in advance