PivotTable.bas

Attribute VB_Name = "PivotTable"
Public PIVOTTABLE_AREA_NONE As Long
Public PIVOTTABLE_AREA_ROW_LABELS As Long
Public PIVOTTABLE_AREA_COLUMN_LABELS As Long
Public PIVOTTABLE_AREA_REPORT_FILTER As Long
Public PIVOTTABLE_SORT_A_TO_Z As Long
Public PIVOTTABLE_SORT_IN_DATA_SOURCE_ORDER As Long
Public PIVOTTABLE_SORT_Z_TO_A As Long
Public PIVOTTABLE_SORT_MANUAL As Long
Public PIVOTTABLE_PIVOT_STYLE_NONE As String
Public PIVOTTABLE_PIVOT_STYLE_LIGHT_1 As String
Public PIVOTTABLE_PIVOT_STYLE_LIGHT_2 As String
Public PIVOTTABLE_PIVOT_STYLE_LIGHT_3 As String
Public PIVOTTABLE_PIVOT_STYLE_LIGHT_4 As String
Public PIVOTTABLE_PIVOT_STYLE_LIGHT_5 As String
Public PIVOTTABLE_PIVOT_STYLE_LIGHT_6 As String
Public PIVOTTABLE_PIVOT_STYLE_LIGHT_7 As String
Public PIVOTTABLE_PIVOT_STYLE_LIGHT_8 As String
Public PIVOTTABLE_PIVOT_STYLE_LIGHT_9 As String
Public PIVOTTABLE_PIVOT_STYLE_LIGHT_10 As String
Public PIVOTTABLE_PIVOT_STYLE_LIGHT_11 As String
Public PIVOTTABLE_PIVOT_STYLE_LIGHT_12 As String
Public PIVOTTABLE_PIVOT_STYLE_LIGHT_13 As String
Public PIVOTTABLE_PIVOT_STYLE_LIGHT_14 As String
Public PIVOTTABLE_PIVOT_STYLE_LIGHT_15 As String
Public PIVOTTABLE_PIVOT_STYLE_LIGHT_16 As String
Public PIVOTTABLE_PIVOT_STYLE_LIGHT_17 As String
Public PIVOTTABLE_PIVOT_STYLE_LIGHT_18 As String
Public PIVOTTABLE_PIVOT_STYLE_LIGHT_19 As String
Public PIVOTTABLE_PIVOT_STYLE_LIGHT_20 As String
Public PIVOTTABLE_PIVOT_STYLE_LIGHT_21 As String
Public PIVOTTABLE_PIVOT_STYLE_LIGHT_22 As String
Public PIVOTTABLE_PIVOT_STYLE_LIGHT_23 As String
Public PIVOTTABLE_PIVOT_STYLE_LIGHT_24 As String
Public PIVOTTABLE_PIVOT_STYLE_LIGHT_25 As String
Public PIVOTTABLE_PIVOT_STYLE_LIGHT_26 As String
Public PIVOTTABLE_PIVOT_STYLE_LIGHT_27 As String
Public PIVOTTABLE_PIVOT_STYLE_LIGHT_28 As String
Public PIVOTTABLE_PIVOT_STYLE_MEDIUM_1 As String
Public PIVOTTABLE_PIVOT_STYLE_MEDIUM_2 As String
Public PIVOTTABLE_PIVOT_STYLE_MEDIUM_3 As String
Public PIVOTTABLE_PIVOT_STYLE_MEDIUM_4 As String
Public PIVOTTABLE_PIVOT_STYLE_MEDIUM_5 As String
Public PIVOTTABLE_PIVOT_STYLE_MEDIUM_6 As String
Public PIVOTTABLE_PIVOT_STYLE_MEDIUM_7 As String
Public PIVOTTABLE_PIVOT_STYLE_MEDIUM_8 As String
Public PIVOTTABLE_PIVOT_STYLE_MEDIUM_9 As String
Public PIVOTTABLE_PIVOT_STYLE_MEDIUM_10 As String
Public PIVOTTABLE_PIVOT_STYLE_MEDIUM_11 As String
Public PIVOTTABLE_PIVOT_STYLE_MEDIUM_12 As String
Public PIVOTTABLE_PIVOT_STYLE_MEDIUM_13 As String
Public PIVOTTABLE_PIVOT_STYLE_MEDIUM_14 As String
Public PIVOTTABLE_PIVOT_STYLE_MEDIUM_15 As String
Public PIVOTTABLE_PIVOT_STYLE_MEDIUM_16 As String
Public PIVOTTABLE_PIVOT_STYLE_MEDIUM_17 As String
Public PIVOTTABLE_PIVOT_STYLE_MEDIUM_18 As String
Public PIVOTTABLE_PIVOT_STYLE_MEDIUM_19 As String
Public PIVOTTABLE_PIVOT_STYLE_MEDIUM_20 As String
Public PIVOTTABLE_PIVOT_STYLE_MEDIUM_21 As String
Public PIVOTTABLE_PIVOT_STYLE_MEDIUM_22 As String
Public PIVOTTABLE_PIVOT_STYLE_MEDIUM_23 As String
Public PIVOTTABLE_PIVOT_STYLE_MEDIUM_24 As String
Public PIVOTTABLE_PIVOT_STYLE_MEDIUM_25 As String
Public PIVOTTABLE_PIVOT_STYLE_MEDIUM_26 As String
Public PIVOTTABLE_PIVOT_STYLE_MEDIUM_27 As String
Public PIVOTTABLE_PIVOT_STYLE_MEDIUM_28 As String
Public PIVOTTABLE_PIVOT_STYLE_DARK_1 As String
Public PIVOTTABLE_PIVOT_STYLE_DARK_2 As String
Public PIVOTTABLE_PIVOT_STYLE_DARK_3 As String
Public PIVOTTABLE_PIVOT_STYLE_DARK_4 As String
Public PIVOTTABLE_PIVOT_STYLE_DARK_5 As String
Public PIVOTTABLE_PIVOT_STYLE_DARK_6 As String
Public PIVOTTABLE_PIVOT_STYLE_DARK_7 As String
Public PIVOTTABLE_PIVOT_STYLE_DARK_8 As String
Public PIVOTTABLE_PIVOT_STYLE_DARK_9 As String
Public PIVOTTABLE_PIVOT_STYLE_DARK_10 As String
Public PIVOTTABLE_PIVOT_STYLE_DARK_11 As String
Public PIVOTTABLE_PIVOT_STYLE_DARK_12 As String
Public PIVOTTABLE_PIVOT_STYLE_DARK_13 As String
Public PIVOTTABLE_PIVOT_STYLE_DARK_14 As String
Public PIVOTTABLE_PIVOT_STYLE_DARK_15 As String
Public PIVOTTABLE_PIVOT_STYLE_DARK_16 As String
Public PIVOTTABLE_PIVOT_STYLE_DARK_17 As String
Public PIVOTTABLE_PIVOT_STYLE_DARK_18 As String
Public PIVOTTABLE_PIVOT_STYLE_DARK_19 As String
Public PIVOTTABLE_PIVOT_STYLE_DARK_20 As String
Public PIVOTTABLE_PIVOT_STYLE_DARK_21 As String
Public PIVOTTABLE_PIVOT_STYLE_DARK_22 As String
Public PIVOTTABLE_PIVOT_STYLE_DARK_23 As String
Public PIVOTTABLE_PIVOT_STYLE_DARK_24 As String
Public PIVOTTABLE_PIVOT_STYLE_DARK_25 As String
Public PIVOTTABLE_PIVOT_STYLE_DARK_26 As String
Public PIVOTTABLE_PIVOT_STYLE_DARK_27 As String
Public PIVOTTABLE_PIVOT_STYLE_DARK_28 As String
Public PIVOTTABLE_AUTOFORMAT_REPORT_1 As String
Public PIVOTTABLE_AUTOFORMAT_REPORT_2 As String
Public PIVOTTABLE_AUTOFORMAT_REPORT_3 As String
Public PIVOTTABLE_AUTOFORMAT_REPORT_4 As String
Public PIVOTTABLE_AUTOFORMAT_REPORT_5 As String
Public PIVOTTABLE_AUTOFORMAT_REPORT_6 As String
Public PIVOTTABLE_AUTOFORMAT_REPORT_7 As String
Public PIVOTTABLE_AUTOFORMAT_REPORT_8 As String
Public PIVOTTABLE_AUTOFORMAT_REPORT_9 As String
Public PIVOTTABLE_AUTOFORMAT_REPORT_10 As String
Public PIVOTTABLE_AUTOFORMAT_TABLE_1 As String
Public PIVOTTABLE_AUTOFORMAT_TABLE_2 As String
Public PIVOTTABLE_AUTOFORMAT_TABLE_3 As String
Public PIVOTTABLE_AUTOFORMAT_TABLE_4 As String
Public PIVOTTABLE_AUTOFORMAT_TABLE_5 As String
Public PIVOTTABLE_AUTOFORMAT_TABLE_6 As String
Public PIVOTTABLE_AUTOFORMAT_TABLE_7 As String
Public PIVOTTABLE_AUTOFORMAT_TABLE_8 As String
Public PIVOTTABLE_AUTOFORMAT_TABLE_9 As String
Public PIVOTTABLE_AUTOFORMAT_TABLE_10 As String
Public PIVOTTABLE_AUTOFORMAT_PIVOTTABLE_CLASIC As String
Public PIVOTTABLE_AUTOFORMAT_NONE As String
Public PIVOTTABLE_SUBTOTAL_NONE As Long
Public PIVOTTABLE_SUBTOTAL_AUTOMATIC As Long
Public PIVOTTABLE_SUBTOTAL_SUM As Long
Public PIVOTTABLE_SUBTOTAL_COUNTA As Long
Public PIVOTTABLE_SUBTOTAL_AVERAGE As Long
Public PIVOTTABLE_SUBTOTAL_MAX As Long
Public PIVOTTABLE_SUBTOTAL_MIN As Long
Public PIVOTTABLE_SUBTOTAL_PRODUCT As Long
Public PIVOTTABLE_SUBTOTAL_COUNT As Long
Public PIVOTTABLE_SUBTOTAL_STDEV As Long
Public PIVOTTABLE_SUBTOTAL_STDEVP As Long
Public PIVOTTABLE_SUBTOTAL_VAR As Long
Public PIVOTTABLE_SUBTOTAL_VARP As Long
Public PIVOTTABLE_SUM_VALUES_FIELD As String

Sub Initialize()
    PIVOTTABLE_AREA_NONE = 0
    PIVOTTABLE_AREA_ROW_LABELS = 1
    PIVOTTABLE_AREA_COLUMN_LABELS = 2
    PIVOTTABLE_AREA_REPORT_FILTER = 4
    PIVOTTABLE_SORT_A_TO_Z = 0
    PIVOTTABLE_SORT_IN_DATA_SOURCE_ORDER = 1
    PIVOTTABLE_SORT_Z_TO_A = 2
    PIVOTTABLE_SORT_MANUAL = 3
    PIVOTTABLE_PIVOT_STYLE_NONE = "None"
    PIVOTTABLE_PIVOT_STYLE_LIGHT_1 = "PivotStyleLight1"
    PIVOTTABLE_PIVOT_STYLE_LIGHT_2 = "PivotStyleLight2"
    PIVOTTABLE_PIVOT_STYLE_LIGHT_3 = "PivotStyleLight3"
    PIVOTTABLE_PIVOT_STYLE_LIGHT_4 = "PivotStyleLight4"
    PIVOTTABLE_PIVOT_STYLE_LIGHT_5 = "PivotStyleLight5"
    PIVOTTABLE_PIVOT_STYLE_LIGHT_6 = "PivotStyleLight6"
    PIVOTTABLE_PIVOT_STYLE_LIGHT_7 = "PivotStyleLight7"
    PIVOTTABLE_PIVOT_STYLE_LIGHT_8 = "PivotStyleLight8"
    PIVOTTABLE_PIVOT_STYLE_LIGHT_9 = "PivotStyleLight9"
    PIVOTTABLE_PIVOT_STYLE_LIGHT_10 = "PivotStyleLight10"
    PIVOTTABLE_PIVOT_STYLE_LIGHT_11 = "PivotStyleLight11"
    PIVOTTABLE_PIVOT_STYLE_LIGHT_12 = "PivotStyleLight12"
    PIVOTTABLE_PIVOT_STYLE_LIGHT_13 = "PivotStyleLight13"
    PIVOTTABLE_PIVOT_STYLE_LIGHT_14 = "PivotStyleLight14"
    PIVOTTABLE_PIVOT_STYLE_LIGHT_15 = "PivotStyleLight15"
    PIVOTTABLE_PIVOT_STYLE_LIGHT_16 = "PivotStyleLight16"
    PIVOTTABLE_PIVOT_STYLE_LIGHT_17 = "PivotStyleLight17"
    PIVOTTABLE_PIVOT_STYLE_LIGHT_18 = "PivotStyleLight18"
    PIVOTTABLE_PIVOT_STYLE_LIGHT_19 = "PivotStyleLight19"
    PIVOTTABLE_PIVOT_STYLE_LIGHT_20 = "PivotStyleLight20"
    PIVOTTABLE_PIVOT_STYLE_LIGHT_21 = "PivotStyleLight21"
    PIVOTTABLE_PIVOT_STYLE_LIGHT_22 = "PivotStyleLight22"
    PIVOTTABLE_PIVOT_STYLE_LIGHT_23 = "PivotStyleLight23"
    PIVOTTABLE_PIVOT_STYLE_LIGHT_24 = "PivotStyleLight24"
    PIVOTTABLE_PIVOT_STYLE_LIGHT_25 = "PivotStyleLight25"
    PIVOTTABLE_PIVOT_STYLE_LIGHT_26 = "PivotStyleLight26"
    PIVOTTABLE_PIVOT_STYLE_LIGHT_27 = "PivotStyleLight27"
    PIVOTTABLE_PIVOT_STYLE_LIGHT_28 = "PivotStyleLight28"
    PIVOTTABLE_PIVOT_STYLE_MEDIUM_1 = "PivotStyleMedium1"
    PIVOTTABLE_PIVOT_STYLE_MEDIUM_2 = "PivotStyleMedium2"
    PIVOTTABLE_PIVOT_STYLE_MEDIUM_3 = "PivotStyleMedium3"
    PIVOTTABLE_PIVOT_STYLE_MEDIUM_4 = "PivotStyleMedium4"
    PIVOTTABLE_PIVOT_STYLE_MEDIUM_5 = "PivotStyleMedium5"
    PIVOTTABLE_PIVOT_STYLE_MEDIUM_6 = "PivotStyleMedium6"
    PIVOTTABLE_PIVOT_STYLE_MEDIUM_7 = "PivotStyleMedium7"
    PIVOTTABLE_PIVOT_STYLE_MEDIUM_8 = "PivotStyleMedium8"
    PIVOTTABLE_PIVOT_STYLE_MEDIUM_9 = "PivotStyleMedium9"
    PIVOTTABLE_PIVOT_STYLE_MEDIUM_10 = "PivotStyleMedium10"
    PIVOTTABLE_PIVOT_STYLE_MEDIUM_11 = "PivotStyleMedium11"
    PIVOTTABLE_PIVOT_STYLE_MEDIUM_12 = "PivotStyleMedium12"
    PIVOTTABLE_PIVOT_STYLE_MEDIUM_13 = "PivotStyleMedium13"
    PIVOTTABLE_PIVOT_STYLE_MEDIUM_14 = "PivotStyleMedium14"
    PIVOTTABLE_PIVOT_STYLE_MEDIUM_15 = "PivotStyleMedium15"
    PIVOTTABLE_PIVOT_STYLE_MEDIUM_16 = "PivotStyleMedium16"
    PIVOTTABLE_PIVOT_STYLE_MEDIUM_17 = "PivotStyleMedium17"
    PIVOTTABLE_PIVOT_STYLE_MEDIUM_18 = "PivotStyleMedium18"
    PIVOTTABLE_PIVOT_STYLE_MEDIUM_19 = "PivotStyleMedium19"
    PIVOTTABLE_PIVOT_STYLE_MEDIUM_20 = "PivotStyleMedium20"
    PIVOTTABLE_PIVOT_STYLE_MEDIUM_21 = "PivotStyleMedium21"
    PIVOTTABLE_PIVOT_STYLE_MEDIUM_22 = "PivotStyleMedium22"
    PIVOTTABLE_PIVOT_STYLE_MEDIUM_23 = "PivotStyleMedium23"
    PIVOTTABLE_PIVOT_STYLE_MEDIUM_24 = "PivotStyleMedium24"
    PIVOTTABLE_PIVOT_STYLE_MEDIUM_25 = "PivotStyleMedium25"
    PIVOTTABLE_PIVOT_STYLE_MEDIUM_26 = "PivotStyleMedium26"
    PIVOTTABLE_PIVOT_STYLE_MEDIUM_27 = "PivotStyleMedium27"
    PIVOTTABLE_PIVOT_STYLE_MEDIUM_28 = "PivotStyleMedium28"
    PIVOTTABLE_PIVOT_STYLE_DARK_1 = "PivotStyleDark1"
    PIVOTTABLE_PIVOT_STYLE_DARK_2 = "PivotStyleDark2"
    PIVOTTABLE_PIVOT_STYLE_DARK_3 = "PivotStyleDark3"
    PIVOTTABLE_PIVOT_STYLE_DARK_4 = "PivotStyleDark4"
    PIVOTTABLE_PIVOT_STYLE_DARK_5 = "PivotStyleDark5"
    PIVOTTABLE_PIVOT_STYLE_DARK_6 = "PivotStyleDark6"
    PIVOTTABLE_PIVOT_STYLE_DARK_7 = "PivotStyleDark7"
    PIVOTTABLE_PIVOT_STYLE_DARK_8 = "PivotStyleDark8"
    PIVOTTABLE_PIVOT_STYLE_DARK_9 = "PivotStyleDark9"
    PIVOTTABLE_PIVOT_STYLE_DARK_10 = "PivotStyleDark10"
    PIVOTTABLE_PIVOT_STYLE_DARK_11 = "PivotStyleDark11"
    PIVOTTABLE_PIVOT_STYLE_DARK_12 = "PivotStyleDark12"
    PIVOTTABLE_PIVOT_STYLE_DARK_13 = "PivotStyleDark13"
    PIVOTTABLE_PIVOT_STYLE_DARK_14 = "PivotStyleDark14"
    PIVOTTABLE_PIVOT_STYLE_DARK_15 = "PivotStyleDark15"
    PIVOTTABLE_PIVOT_STYLE_DARK_16 = "PivotStyleDark16"
    PIVOTTABLE_PIVOT_STYLE_DARK_17 = "PivotStyleDark17"
    PIVOTTABLE_PIVOT_STYLE_DARK_18 = "PivotStyleDark18"
    PIVOTTABLE_PIVOT_STYLE_DARK_19 = "PivotStyleDark19"
    PIVOTTABLE_PIVOT_STYLE_DARK_20 = "PivotStyleDark20"
    PIVOTTABLE_PIVOT_STYLE_DARK_21 = "PivotStyleDark21"
    PIVOTTABLE_PIVOT_STYLE_DARK_22 = "PivotStyleDark22"
    PIVOTTABLE_PIVOT_STYLE_DARK_23 = "PivotStyleDark23"
    PIVOTTABLE_PIVOT_STYLE_DARK_24 = "PivotStyleDark24"
    PIVOTTABLE_PIVOT_STYLE_DARK_25 = "PivotStyleDark25"
    PIVOTTABLE_PIVOT_STYLE_DARK_26 = "PivotStyleDark26"
    PIVOTTABLE_PIVOT_STYLE_DARK_27 = "PivotStyleDark27"
    PIVOTTABLE_PIVOT_STYLE_DARK_28 = "PivotStyleDark28"
    PIVOTTABLE_AUTOFORMAT_REPORT_1 = "Report1"
    PIVOTTABLE_AUTOFORMAT_REPORT_2 = "Report2"
    PIVOTTABLE_AUTOFORMAT_REPORT_3 = "Report3"
    PIVOTTABLE_AUTOFORMAT_REPORT_4 = "Report4"
    PIVOTTABLE_AUTOFORMAT_REPORT_5 = "Report5"
    PIVOTTABLE_AUTOFORMAT_REPORT_6 = "Report6"
    PIVOTTABLE_AUTOFORMAT_REPORT_7 = "Report7"
    PIVOTTABLE_AUTOFORMAT_REPORT_8 = "Report8"
    PIVOTTABLE_AUTOFORMAT_REPORT_9 = "Report9"
    PIVOTTABLE_AUTOFORMAT_REPORT_10 = "Report10"
    PIVOTTABLE_AUTOFORMAT_TABLE_1 = "Table1"
    PIVOTTABLE_AUTOFORMAT_TABLE_2 = "Table2"
    PIVOTTABLE_AUTOFORMAT_TABLE_3 = "Table3"
    PIVOTTABLE_AUTOFORMAT_TABLE_4 = "Table4"
    PIVOTTABLE_AUTOFORMAT_TABLE_5 = "Table5"
    PIVOTTABLE_AUTOFORMAT_TABLE_6 = "Table6"
    PIVOTTABLE_AUTOFORMAT_TABLE_7 = "Table7"
    PIVOTTABLE_AUTOFORMAT_TABLE_8 = "Table8"
    PIVOTTABLE_AUTOFORMAT_TABLE_9 = "Table9"
    PIVOTTABLE_AUTOFORMAT_TABLE_10 = "Table10"
    PIVOTTABLE_AUTOFORMAT_PIVOTTABLE_CLASIC = "PivotTableClasic"
    PIVOTTABLE_AUTOFORMAT_NONE = "None"
    PIVOTTABLE_SUBTOTAL_NONE = 0
    PIVOTTABLE_SUBTOTAL_AUTOMATIC = 1
    PIVOTTABLE_SUBTOTAL_SUM = 2
    PIVOTTABLE_SUBTOTAL_COUNTA = 3
    PIVOTTABLE_SUBTOTAL_AVERAGE = 4
    PIVOTTABLE_SUBTOTAL_MAX = 5
    PIVOTTABLE_SUBTOTAL_MIN = 6
    PIVOTTABLE_SUBTOTAL_PRODUCT = 7
    PIVOTTABLE_SUBTOTAL_COUNT = 8
    PIVOTTABLE_SUBTOTAL_STDEV = 9
    PIVOTTABLE_SUBTOTAL_STDEVP = 10
    PIVOTTABLE_SUBTOTAL_VAR = 11
    PIVOTTABLE_SUBTOTAL_VARP = 12
    PIVOTTABLE_SUM_VALUES_FIELD = "#SUM_VALUES#"
End Sub