| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot tables and array variables
I'd like to use some array variables that I populate in VBA to create a pivot
table cache. 1. Is this possible? 2. If so, how? In the past, I've successfully used lines like set pivotcache.recordset = recordset to set the pivot cache equal to a recordset opened from an ODBC connection. This time, I'd like to set the pivot cache equal to a set of array variables. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Average Salaries with Three Other Variables - Pivot Tables? | Excel Worksheet Functions | |||
| Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
| Using variables with pivot tables | Excel Discussion (Misc queries) | |||
| Array or Pivot Tables??? | Excel Programming | |||
| Pivot tables-controlling user interaction with pivot tables | Excel Programming | |||
Threaded Mode
