Need Help w/Expression

G

Gcook888

I found article KB 298046 says to use Office Web Components object model to
filter a PivotTable.

Use the IncludedMembers or ExcludedMembers property of a Field Object.

So they have a sample

Dim pField As OWC10.PivotField
Set pField = pFieldset.Fields("LastName")
pField.IncludedMembers = Array("Smith","Wesson","Eastwood")

I want to filter on a date range. For ex 10/31/01 - 12/31/01 and all possible
dates between the start and end dates may not be accounted for.

In other words I have
pField.IncludedMembers = ?

what ? would do it?
thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top