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!

I don't think you can do it that way, after all, a pivot table is based off
underlying data.

You need to put the data into a table first then assign the table to a
PivotCache and from the cache create the pivot table

"groupie" <(E-Mail Removed)> wrote in message
news:65857cb1-a5f5-40d4-8eb5-(E-Mail Removed)...
> 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!

On May 20, 3:50*pm, "Patrick Molloy" <patrick_mol...@hotmail.com>
wrote:
> I don't think you can do it that way, after all, a pivot table is based off
> underlying data.
>
> You need to put the data into a table first then assign the table to a
> PivotCache and from the cache create the pivot table
>
> "groupie" <justforgro...@gmail.com> wrote in message
>
> news:65857cb1-a5f5-40d4-8eb5-(E-Mail Removed)...
>
>
>
> > 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!- Hide quoted text -
>
> - Show quoted text -

Hi,
Thanks for the reply.
Would you have an example of that? Don't see anything on Google.

Thanks,