Sebastien,

I see the help that you recommended, and it looks to be exactly what I need.

I will try it very soon.

Thanks again.

Mark

"sebastienm" wrote:

Actually, you can also set the recordset to the pivot cache as a data source
for the pivot table... which is what you requested in your question.
An example is given in the xl help for Recordset.
--
Regards,
Sébastien
<http://www.ondemandanalysis.com