>>>The following code works great in earlier versions of Excel but 2007 changes things.
>>>this line just hangs

>>> oPivotTable = oPivotCache.CreatePivotTable( oTargetRange, "PivotTable" )

>>>Does anyone know if Tamar has released anything new on her wonderful "Office Automation Book"
>>
>>Andrew,
>>That CreatePivotTable syntax works perfectly well under Excel2007. I think the problem is in elsewhere. Probably you didn't only change the excel version.
>>Cetin
>Thanks Cetin
>This is a new Vista machine and it looks like I have problems with the ODBC driver for VFP
>When I try to set up the Visual Foxpro Drivers it tells me to go to msdn.microsoft.com/vfoxpro/downloads and get the latest ODBC which i have done and run but I am now in an endless loop where it keeps refering me to the web site for the latest ODBC for VFP - this is VFP9 SP1 - any pointers in this area - its very frustrating.
>regards

Andrew,
Do not use ODBC driver. Last one was released with MDAC 2.5 or 2.6 and is not compatible with VFP9. Use VFPOLEDB driver instead.
Cetin