Programming Pivot Tables

Hi,
I need to be able to (programmatically) browse to a pivot table, and be able to read & change it's datasource.
Is this possible?

Reason is the dba will be moving our analysis server's databases and cubes to another server.

Currently, users got a lot of pivot tables and templates that point to the current location of the cubes used.

I was thinking of creating an app that allow the user to select all his pivot tables (xls documents) and then in code change the data source of each table.

Any better suggestions?

Regards