Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format PivotTable from VBA out of MS Access
Hi,
I have created different functions which move certain data from MS Access to Excel in an PivotTable and PivotChart. The PivotChart formatting works, however I try now to format the PivotTable itself but it always fails - or at lesast I don't know what to do exactly. I use version 2002. Here some samples: With xlAPP.ActiveChart .HasTitle = True .ChartTitle.Characters.Text = "Title" End With Setup of Pivot Table: With xlAPP.ActiveSheet.PivotTables("PivotIndex") .PivotFields("Category").Orientation = xlRowField .PivotFields("Series").Orientation = xlColumnField .ColumnGrand = False .RowGrand = False End With With xlAPP.ActiveSheet.PivotTables("PivotIndex").PivotF ields("ChartValue") .Orientation = xlDataField .Function = xlSum .Position = 1 End With However the same for the PivotTable seems not to work: (as mentioned I like to format the font, size, etc...) xlAPP.ActiveSheet.PivotTables("PivotIndex").PivotF ields("Series").Font.Name = "HelveticaNeueLT Std Cn" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to remove PivotTable format. | Excel Worksheet Functions | |||
Getting rid of PivotTable format | Excel Worksheet Functions | |||
Format PivotTable | Excel Discussion (Misc queries) | |||
I NEED TO KNOW THE SOURCE OF A PIVOTTABLE FROM ACCESS | Excel Discussion (Misc queries) | |||
Create Excel PivotTable that uses Access query as external data so | Excel Programming |