Default value selected programatically in pivot table

[Jer]

I am using the OWC pivot table to display a cube that I have developed
and there are two fields on the filter Axis, these are account and
date, I would like to set these two fields to a particular value upon
loading of the control:

For example the current code is:

set fieldDef = .FieldSets("Account")
fieldDef.Fields(0).Caption = "Account"
..filterAxis.insertFieldSet fieldDef

..filteraxis.insertfieldset .fieldsets("As of Date")

' Now I would like to set the Account value to 3518 (a known account)
' And set the as of date to 08/01/2007
' Also is there any way to get rid of the All member as it is not
really valid?

Is this possible and if so how do I do it?

Thanks


Jeremy.