Pivot Connections vs pivotcache.commandtext -- how to identify

[peraxhil]

I have a workbook with 5 pivot tables. There are 3 different Connection Names.

I need to update the underlying queries .. Using Pivotcache.commandtext. But the queries are different for each connection name. I would like to loop through the Conn.name and then based on the connection name, change to a specific query. I know this isn't correct but the rough logic would be

Please Login or Register  to view this content.

I need some ideas on how to approach this issue.

Thanks

[peraxhil]

This is a test reply