Extracting elements via vba

[telula]

Hello,
Below is my dynamic subset of the Division dimension.
{FILTER( { DRILLDOWNMEMBER( {TM1SubsetBasis()}, {[Division].[2]} ) }, [Division].[Display] = "Yes")}

I am trying to get the syntax to run this via VBA.I know the syntax for running MDX to select from cubes but I havent seen an example where I am extracting elements from dimension via vba.I dont want to create this dynamic subset only at runtime.

[Wim Gielis]

Hi

What comes to mind at first sight, is simply a loop through the elements of the dimension, and checking the Display attribute. AFAIK, I did not implement MDX statements using VBA.

Wim