Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have a list of fields in a string and woudl liek to create a pivot table from them, but am not sure how to proceed. The fields are in a string with a , delimitor but I have also parsed them into an array in case I could do it that way: sPageFields = "field1, field2, field 3, field4" Arr = SplitMultiDelims(sPageFields, ",") 'arr[0] = field1, arr [1] = field2, etc... ' -- how to populate?:: oPT.AddFields RowFields:="Data", PageFields:=Array(" & Arr(iLoop) & ") or oPT.AddFields RowFields:="Data", PageFields:=Array(" & sPageFields & ") Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
(repost) Dynamically creating pivot tables from page-field list | Excel Programming | |||
Creating Pivot tables dynamically from page filter values summary | Excel Programming | |||
Dynamically refreshing Pivot Table Range. | Excel Programming | |||
Pivot Table Dynamically Creating on Query | Excel Programming | |||
Can we create pivot table dynamically | Excel Programming |