Creating local cube using PivotTable

D

dzeaman

I tried to write a macro while creating a local cube, and Excel wrote this
VB-code:
With ActiveSheet.PivotTables("Table1").PivotCache
.LocalConnection = _
"OLEDB;Provider=MSOLAP;Data Source=C:\test.cub;Initial Catalog=Test"
.UseLocalConnection = True
End With

But when I tried to execute this macro, there was an "Application defined or
object defined error". The cube was created but had no data.

First question: why?

Second question: if I will not create a microcube using this method, what
can I do to create a local cube in VBA from existing PivotTable?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating local cube using PivotTable 0
Create a pivot table with a local connection 0
PivotFilters in pivottable 0
problems with a localconnection to a cub file 0
Excel 2007 - Local Cube - Pivot Table 0
Macro and Pivot tables using a CUBE as data source 0
Create CubeFields with C# 1
Can't change pivotfilter value1 parameter in code 0

Top