以下是引用菱角在2004-6-11 14:36:00的发言:
dim i as integer
dim wb as workbook
for i=1 to 10 '生十個
set wb=workbooks.add
ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _
"[" & thisworkbook.name & "]销售明细!R1C1:R114C10").CreatePivotTable TableDestination:="[" & wb.name & "]汇总核对!R6C1", _
TableName:="销售数据透视表", DefaultVersion:=xlPivotTableVersion10
wb.close savechanges:=true
next
引申:
(1) 在多个文件中生成特定名称的多个透视表
Sub MultiPivot()
Dim i As Integer
Dim wb As Workbook
For i = 1 To 10 '生十個
Set wb = Workbooks.Add
ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _
"[" & ThisWorkbook.Name & "]sheet1!R1C1:R10C3").CreatePivotTable TableDestination:="[" & wb.Name & "]sheet1!R6C1", _
TableName:="销售数据透视表", DefaultVersion:=xlPivotTableVersion10
wb.Close savechanges:=True
Next
End Sub
(2) 在同一文件的多个工作表中生成特定名称的多个透视表
Sub MultiPivot1()
Dim i As Integer
Dim wb As Workbook
For i = 1 To 10 '生十個
Set wsht = Worksheets.Add
ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _
"[" & ThisWorkbook.Name & "]sheet1!R1C1:R10C3").CreatePivotTable TableDestination:=wsht.Name & "!R6C1", _
TableName:="销售数据透视表", DefaultVersion:=xlPivotTableVersion10
Next
End Sub
[此贴子已经被作者于2004-6-12 10:12:14编辑过] |