Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't seem to create a Pivot Table with VBA ?
I keep getting errors when trying to create a pivot table from
existing sheet data... I'm actually using a web query to populate the "RawData" sheet, then trying to use that data to create a pivot table... Does anyone have any ideas why this might not be working? Thank in advance, Tim Dim PTCache As PivotCache Dim Table As PivotTable Set PTCache = ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatab ase, SourceData:=Range("RawData!A1:F245")) Set Table = PTCache.CreatePivotTable(TableDestination:=Sheets( "Upgrade Report").Range("a18"), TableName:="ptUpgrade") With Table With .CubeFields(sRowField1) .Orientation = xlRowField .Position = 1 End With If sRowField2 < "none" Then With .CubeFields(sRowField2) .Orientation = xlRowField .Position = 2 End With End If With .CubeFields(sDataField) .Orientation = xlDataField .Position = 1 End With End With |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can't seem to create a Pivot Table with VBA ?
well, if you are getting data from a worksheet, I doubt you would have
Cubefields. Why not turn on the macro recorder and create the table manually using your data. Then turn it off and enrich the recorded code to do what you want. -- Regards, Tom Ogilvy "Tim" wrote in message om... I keep getting errors when trying to create a pivot table from existing sheet data... I'm actually using a web query to populate the "RawData" sheet, then trying to use that data to create a pivot table... Does anyone have any ideas why this might not be working? Thank in advance, Tim Dim PTCache As PivotCache Dim Table As PivotTable Set PTCache = ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatab ase, SourceData:=Range("RawData!A1:F245")) Set Table = PTCache.CreatePivotTable(TableDestination:=Sheets( "Upgrade Report").Range("a18"), TableName:="ptUpgrade") With Table With .CubeFields(sRowField1) .Orientation = xlRowField .Position = 1 End With If sRowField2 < "none" Then With .CubeFields(sRowField2) .Orientation = xlRowField .Position = 2 End With End If With .CubeFields(sDataField) .Orientation = xlDataField .Position = 1 End With End With |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
can I create pivot table from two other pivot tables? | Excel Discussion (Misc queries) | |||
How do I create multiple pivot charts from one pivot table? | Charts and Charting in Excel | |||
pivot table: create worksheetsheet using pivot table | Excel Discussion (Misc queries) | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel |