How to access Power Pivot Model measures uwing Excel VSTO RRS feed

  • Question

  • Hi,

    I am looking to get (read only) all explicit created measures for a Power Pivot Model. I looked at the Power Pivot Object Model here. In this link it is mentioned that there is ModelMeasureNames Collection which I guess is exactly what I want.

    But the problem is I do not know how to access that in the first place. For example if I need to get list of ModelTable (ModelTables collection) then I would use the below :

    ModelTables mdts = ActiveWorkbook.Model.Table

    I am looking if there is similar way to get the Measures too. I searched but could not find anything. I saw a discussion on this link but the answer is no where close as it gives all measures in a pivot table and not in a model.

    Any idea ?

    Please mark responses as answered if it helped you.. This helps others... - Girija Shankar Beuria

    Saturday, December 19, 2015 4:46 PM

All replies

  • We are doing the research about your problem. There might be some delay about the response. Appreciate your patience.
    Wednesday, December 23, 2015 1:16 AM