Coding Datasource for Pivot Table

Hot Topic

VB 2005 Syntax reference PLEASE!!
Problems using GUID
Sending 8-bit Data via Serial Port
Selecting the Row under the mouse cursor automatically
set Visual Basic compiler options programatically
[VB.NET VS2005] Multicolumn combobox
Processing Serial Data
How to data stuff from an Access Database with VB 2005
Controls Flickering when drawed on the form
Having trouble getting a correct value of textbox3

Visual Basic

when I m developping, clicking a control once in a form goes directly to the code window
fade to black and white
ObjectModel.Collection(Of t)
searching within text files
Relase the Fix for Visual Basic Compiler Error &H8013141e&
interacting with data classes
Is there a change method?
expert system
Shell method causes the error "VBX Library init failure" on some machines
Yoda needs help sending Data to Hardware! ALL NERDS COME QUICK!!!

Coding Datasource for Pivot Table

Hi,

I'm on the process of linking my AS2005 cube to VB 2005 using ms pivot table 11.0. However, instead of doing an early binding, I want to code my datasource connection. Do you have any sample on how to do this

Thank you

chemps

Answer this question

Coding Datasource for Pivot Table

  • Rod at Work

    usually, to define the connection of the pivot table is by right-clicking on the axpivottable object and configure the connection there. However, i want to do that in code. every time i used the axpivottable1.connection = <connection string> i get an error. how do i define that connection in code

    thanks

    chemps

  • SubZero

    I am not sure if I understand the question. Here is a link on how to pivot a table and display it.

    http://www.vb-tips.com/default.aspx ID=28f49f7c-ec40-4472-9b28-2b9e762316ab



  • Coding Datasource for Pivot Table
Answer this question