>>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