Get members and assign them to member editer using VBA

[Former Member]

Hi Experts,

I am looking for a way to get members by filtering using VBA. I know how to add member itself using addcol or row axis function in VBA, but still need to know getting members by filtering and put them to a certain dimension before refreshing. I searched a way to set dynamic filter to member editor using VBA, it seems there is noway currently. Therefore I am trying to get members first by filtering using another function.

There is "GetMembers" like the below,

Looks like a function to get members by a certain filter.

Is there anyone can help on this? if you provide a sample code, will be very appreciated.

Best Regards,

YH Seo

[former_member186338 · Accepted solution]

2 options:

1. Use OpenFilteredMemberSelector(...) "42.4.5.19 OpenFilteredMemberSelector" in help.

2. Get all members with properties etc...:

Vadim

[Former Member · Accepted solution]

Hi Vadim,

Thanks a lot!

The answer is what I exactly want to hear. And the code you provided from the link is PERFECT.

Regards,

YH Seo