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
Excel 2007 - Local Cube - Pivot Table 0
pivot table queries created in Excel2000 on a NT box in XP? 0
#N/A values when exporting PivotTable to Excel 0
PivotFilters in pivottable 0
problems with a localconnection to a cub file 0
Connecting OWC to local cube 0

Top