>Hi All,
>
>What is the VFP equivalent to VB's array assignment to PivotTable COM object?
>
>E.g. (VB):
>
>thisform.PivotTable.ActiveView.FieldSets("Store").Fields("Store
>State").FilterMembers=Array("11","22").
>
>
>Is there any way to make it work?
>
>Thanks,

Andy,

VB's Array function returns a zero based array (unless OPTION BASE is set to 1, it's zero, however by default). Use the COMARRAY() function to specify how the VFP array is to be passed.