VBA to remove specific items from a PivotTable Field

[rkl303]

Hello,

I have a Cube that is presented in Excel as a PivotTable that has a field that has 50K members. I was wondering how you would suggest I build a macro that allows me to remove certain items from that field. i.e. I had 40 memebers selected but now I wanted to deselect 3 of them via a user prompted csv string. What is the proper way of doing that?

I was thinking of using this code from stackoverflow:
http://stackoverflow.com/questions/2...able-pagefield
to get the existing values in the possibly filtered string but to me it seems it might take a while if there are 50K members to create an array from and them searching for that item and just making the value "".

Is this the right logic? or is there a much simpler and more elegant solution?

Additionally these members are represented in the actual cube/vba as a key i.e. Project ID GAZEDDD1 is represented as [1] when using cube functions is there an easy way via vba to get that key?

Sincerely,

Richard Lee

[rkl303]

Bump for an Answer.