Have you tried creating an Excel macro, performing the operation manually, then reviewing the VBA code? Sometimes it takes guessing at parameters, but I've found that a pretty reliable way to do automation in Excel.

Sorry, I don't have any xtab-specific code.

Jay

>I have managed to create a class that will allow me to instatiate Excel, add workbooks and sheet, populate the sheets, and format the data. Now I have been asked to generate a pivot table out of a VFP app. Is there a kind soul out there who would be willing to share Pivot Table code with me?
>
>Thank you.
>
>Todd Cottengim
>Alpine Land Information Services
>tcottengim@alpine-lis.com