Programming the PivotTable DataSource

Igor R. Alcantara · Jul 15, 2005

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

psychatricmeuh · Jul 18, 2005

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

VBA to do a mailmerge from a Specific Excel worksheet	0	Jun 17, 2017
VBA Pivot Table: Determining item from one field based on anotherfield item	0	Nov 8, 2013
Criteria for external data in a pivottable	1	Aug 21, 2012
Mail Merge Help	0	Feb 23, 2015
session lost when connect SQL Analysis server throug http	1	Jan 18, 2009
Unable to use AutoCalc function on OWC PivotTable	1	Dec 20, 2007
Dynamic Subject Line Email Merge	0	Oct 7, 2013
a problem about chartSpace's XMLData	1	Jul 13, 2008

Ask a Question