According to this information
http://msdn.microsoft.com/en-us/library/bb213289.aspx

The PivotCache.Recordset property should be able to return a Recordset
object. When I attempt to set rs = PivotCache.Recordset I get a '1004'
error. Is there a special syntax needed to retrieve the PivotCache recordset
object?

Thanks,

George