If your e-mail doesn't work, you can try this:
Download the sample data from
http://www.sunsoft.sk/ftp/test.zipOpen TEST1.XLS - there are two pivottables on the sheet connected to the same pivotcache. Open VFP and try this code:
xl=GETOBJECT(,"Excel.Application")
pc=xl.ActiveWorkbook.PivotCaches(1)
pc.CommandText = 'select * from DS1 ds1'
... and I get error OLE error code 0x800a03ec: Unknown COM status code... :-(
When I open TEST2 with one pivottable, all works fine.
Do you have any idea how to reslove this problem?
Thanks
Norbert