|
Test.zip
(39.71 KB, 下载次数: 22)
请看代码:
当第二次运行时就会出现问题,请高手修改!谢谢!见附件!
Sub Macro3()
'
' Macro3 Macro
' Macro recorded 2009-3-3 by
'
'
Sheets("Summary").Select
Columns("A:K").Select
ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _
"Summary!C1:C11").CreatePivotTable TableDestination:= _
"[Test.xls]Analysis!R6C2", TableName:="PivotTable2", DefaultVersion:= _
xlPivotTableVersion10
ActiveSheet.PivotTables("PivotTable2").AddFields RowFields:="Vendor No."
With ActiveSheet.PivotTables("PivotTable2").PivotFields("PPV")
.Orientation = xlDataField
.Caption = "Sum of PPV"
.Function = xlSum
End With
ActiveWorkbook.ShowPivotTableFieldList = False
End Sub |
|