asked on 9/11/2013

is possible to make a power view or power pivot using vba?

Hi,

How can i make a vba code to create a power view or power pivot in excel? The macro recorder don't do anything. Any idea?

Microsoft Excel

Last Comment

Zack Barresse

9/11/2013

x-men

9/11/2013

ex.:

Sub PowerPivot()
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"Sheet1!R1C1:R4C2", Version:=xlPivotTableVersion12).CreatePivotTable _
TableDestination:="Sheet1!R1C4", TableName:="PivotTable1", DefaultVersion _
:=xlPivotTableVersion12
Sheets("Sheet1").Select
Cells(1, 4).Select
End Sub

Zack Barresse

9/11/2013

@x-men: They're asking for a PowerPivot creation, not a PivotTable.

@joyacv2: You must be using Excel 2010, in which case no, there is no VBA object model for PowerPivot. This was added in Excel 2013, although it's somewhat limited. Here is an example ...

    Workbooks("Book1").Connections.Add2 Name:="LinkedTable_Table1", Description:="", ConnectionString:="WORKSHEET;Book1", _
                                        CommandText:="Book1!Table1", lCmdType:=7, CreateModelConnection:=True, ImportRelationships:=False

Open in new window

HTH
Regards,
Zack Barresse

joyacv2

9/11/2013

ASKER

so, there is no code to manipulate a power view or powerpivot, do you know any other alternative?

ASKER CERTIFIED SOLUTION

Zack Barresse

9/11/2013

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial