Programming the PivotTable DataSource

[Igor R. Alcantara]

How can I change the Pivot Table datasource writing VB.Net Code?

 

[psychatricmeuh]

o_PT = New PivotTableClass
o_PT.ConnectionString = "Provider=MSOLAP.2;User
Id=usr;Password=pwd;Data
Source=http://dbserver/htedirectorywherethereismsolap.asp"
o_PT.DataMember = thecubeyouwant