Hi,

Please see if anyone can help me with this -

I have written to the following VBA code in excel to automate the
process of Offline Cubes creation :-

Sub UseCreateCubeFile()

Sheets("Sheet2").PivotTables("PivotTable1").Create CubeFile _
File:="C:\Documents and Settings\shegupta\Desktop\Sales.cub",
Measures:=Array("[Sales]"), Levels:=Array("[Product].[Company Name]"),
Properties:=False

End Sub

I am getting the error "Invalid Procedure call or argument".
I have checked extensively the HELP available on MSDN / excel help
files / and searched a lot on net, but not able to find any Example
which uses the complete syntax of CreateCubeFile method.

Please help if anyone has used this before. It would be gr8 if anyone
can tell me just the complete syntax of this method that he/she may
have used somewhere.

Thanks
SG