GaryAA
asked on
Excel: Loading pivotcache data into vba array
Hi,
I would like to load the data from an existing pivot cache directly into an array using vba code. I would be very grateful for any help.
Thanks in advance!
Gary
I would like to load the data from an existing pivot cache directly into an array using vba code. I would be very grateful for any help.
Thanks in advance!
Gary
Unless the pivotcache is created from an ADO recordset, you can't do that - you'll have to extract the data from its original source.
ASKER
Thanks for your answer, from my rsearch that appears to be true. With that in mind, how about loading an array directly from the pivot table itself using vba code in a very automated manner. I know how to load a range into an array as follows:
Dim LoadArray1 As Variant
LoadArray1 = Range("datarange")
Is there anything similar to the range concept except with a pivot table?
Dim LoadArray1 As Variant
LoadArray1 = Range("datarange")
Is there anything similar to the range concept except with a pivot table?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.