Skip to Content

How to get "data cell properties" in vba

Anyone know how to access EPM's "data cell properties" values within VBA? For example, the ActiveCell is on a data cell that you want to know the dimensionality of within vba. So, cell A1 "data cell properties" = VERSION=Actual; TIME=2010.TOTAL, etc. I want to use this cell info within my vba macro.

FYI, "data cell properties" are accessed by right clicking on the data cell, then "EPM", "Properties".

EPM 10 SP19 Patch 1 .Net 4

Build 8936

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 20, 2015 at 09:08 PM

    Hi John,

    As far as I know there is no API function to get "data cell properties". But in general you know the location of page, column and row axis and you can simply find the related dimension members with a simple VBA code. In some cases you can use functions:

    GetDataTopLeftCell(woksheet,report)

    GetDataBottomRightCell(woksheet,report)

    To ensure that the cell is in the data area.

    Vadim

    Add comment
    10|10000 characters needed characters exceeded

    • EPMLink can pass context members - no relation with currently selected cell. As I already told you - you can use simple VBA code to get the members from column and row axis related to current cell... What is the issue?