visual c# excel 2007 pivot filter
 

Hi,
I'm trying to add pivot filter with multiple values checked using visual c#
2008, we tried using the xldatebetween syntax property of the pivot function,
but keep getting an error on the object data property.

Can someone please guide me to the right syntax

below is the string from the code

tablePage1.PivotFilters.Add(Excel.XlPivotFilterTyp e.xlDateBetween,tablePivot.PivotFields("Posted
Date"),"12/7/2009", missing, missing, missing, missing, missing);

visual c# excel 2007 pivot filter
 

On Wednesday, 16 December 2009 03:58:15 UTC+5:30, @discussions.microsoft.com Scott wrote:
Hi,
I'm trying to add pivot filter with multiple values checked using visual c#
2008, we tried using the xldatebetween syntax property of the pivot function,
but keep getting an error on the object data property.

Can someone please guide me to the right syntax

below is the string from the code

oPivotField.PivotFilters.Add(XlPivotFilterType.xlT opCount, oPivotTable.PivotFields("UserName"), 5, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);


On Wednesday, 16 December 2009 03:58:15 UTC+5:30, @discussions.microsoft.com Scott wrote:
Hi,
I'm trying to add pivot filter with multiple values checked using visual c#
2008, we tried using the xldatebetween syntax property of the pivot function,
but keep getting an error on the object data property.

Can someone please guide me to the right syntax

below is the string from the code

oPivotField.PivotFilters.Add(XlPivotFilterType.xlT opCount, oPivotTable.PivotFields("UserName"), 5, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);