Excel OLAP Connection Settings

  • Thread starter christophe.leroquais
  • Start date
C

christophe.leroquais

Hi,

I'm using Cubes through Excel 2003 and I'd like to be able to change
the connection settings. For example: I'd like top change the server
name.
Any ideas how to do that???

Help much appreciated.

Chris
 
M

Miguel Zapico

The connection string can be accessed with VBA. Check the value of
activeworkbook.PivotCaches.Item(1).Connection, you may create a macro that
craft a different connection string for different servers using that property.

Hope this helps,
Miguel.
 
Top