phireone.blogg.se

• #Excel 2008 for mac pivot table how to

Here’s are the two VBA Macro I’m trying to convert:ĪctiveSheet.PivotTableWizard SourceType:=xlDatabase, SourceData:= _

#Excel 2008 for mac pivot table how to

I’ve found some references on how to manipulate the Pivot Table, but nothing showing how to create the Pivot Table from scratch.

I don’t use Excel much, so the concept of the Pivot Table is somewhat foreign to me. I have a user who has a VBA Macro that needs to get converted to Applescript because VBA Macros are no longer supported in Excel 2008 for Mac. Subject: Creating, modifying and formatting a pivot table with AS in Excel 2008Ĭan anyone point me in the right direction on how to create a Pivot Table in Excel 2008 with Applescript. Set the pivot field orientation of the pivot field named "currentTask" of PTable to orient as data fieldĬonversation: Creating, modifying and formatting a pivot table with AS in Excel 2008 Set subtotals pf subtotal index 1 without value Set pf to pivot field i of pivot table PTTableName of active sheet sets PivotTable Row Fields to Subtotal of None Set PTRows to Īdd fields to pivot table PTable row fields PTRows page fields PTFields with add to table This seems really slow compared to the Excel 2004 VB macro. Title: Re: Creating, modifying and formatting a pivot table with AS in Excel 2008 Here’s what I’ve come up with so far.