Hi --

I am trying to create a pivot table from a dynamic query - so I create the
query in VBA and then want to create a pivot table with that query. What I
am trying to do is to first create the pivotcache. I am pretty lost on this
one - I can create a cache with Excel data, but am having a hard time
creating it from a recordset.

Any ideas?

Thank you -