See the following link:

http://support.microsoft.com/default.aspx?scid=http%3a%2f%2fsupport.microsoft.com/common/canned.aspx%3fR%3dd%26H%3dProgramming%2bExcel%2b2000%2bPivotTable%2bArticles%26LL%3dkbExcel2000Search%26Sz%3dPivotTable%2band%2bkbVBA

I believe there is some specific code in the Office Automation book available from Hentzenwerke: http://www.hentzenwerke.com/catalogavailability/autofox.htm

>>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
>
>Can't you use the Pivot Table Wizard? It's re-distributable.