Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for Pivot Table - Apply to multiple workbooks
Tom,
I am having problems running this macro on Excel 97. Excel 97 doesn't recognize the workbook/worksheets/pivottablewizard names that I have coded below. Could you please give me some advise as to how I could get Excel 97 to recognize the coding below. Thanks again. Dim rng As Range Set rng = ActiveWorkbook.Worksheets ("POSTEDBYJOURNAL").Range("A7").CurrentRegion ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatab ase, SourceData:= _ rng.Address(True, True, xlR1C1, True)).CreatePivotTable TableDestination:="", TableName _ :="PivotTable1" ActiveSheet.PivotTableWizard TableDestination:=ActiveSheet.Cells(3, 1) ActiveSheet.Cells(3, 1).Select -----Original Message----- Tom, Thank you for your response. This is exactly what I needed! Thanks again, Nathan *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Apply Filter to source of Pivot Table | Excel Worksheet Functions | |||
How to apply macro across multiple worksheets within a workbook | Excel Discussion (Misc queries) | |||
Pivot Table from 2 different workbooks | Excel Discussion (Misc queries) | |||
Apply autofilter selections to 2nd table automatically? Macro? | Excel Worksheet Functions | |||
Apply a formula as a pivot table calc or suggestion | Excel Worksheet Functions |