Skip to Content

EPM Report Automation using Excel VBA

Hi,

I am trying to automate an EPM report using Excel VBA. While I am able to refresh the report I am unable to add the member values to Column Axis. The values are calendar days and are in format mm/dd/yyyy. Would appreciate if you could help me with the VB code to add values to the column axis.

Regards,

Jitender

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Nov 23, 2018 at 10:12 AM
    Add comment
    10|10000 characters needed characters exceeded

    • Hi Vadim, apologies for the late response. I have tried using the example at the link you provided however I was unable to frame the code as per my requirement. Unfortunately I would not be able to provide a screenshot. Below is a brief of my requirement

      The column axis is CalendarDay

      I need to add the date value which is available in Row 3 of the excel tab "Asset" to the column Axis

      so for instance Cell C3 has the value 01/01/2019, D3 = 01/02/2019, E3 = 01/03/2019 ... so on and so forth. I need to add these values to the column axis. Please advise.

  • Jan 22 at 11:07 AM

    Sorry, but looks like you want me to do your job (write code), even without providing a clear screenshot?

    And what's wrong with AddMemberToColumnAxis??? I have used it number of times without issues! Before using this method column axis need to contain at least one member.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 22 at 11:19 AM

    Tried the below codes however they don't seem to work -

    Sub Example()
    Dim epm As New FPMXLClient.EPMAddInAutomation
    Dim client As Object
    'Set client = Application.COMAddIns("FPMXLClient.Connect").Object
    epm.AddMemberToColumnAxis Asset, "000", "CalendarDay", "20 / 1 / 2019"
    End Sub

    Sub Example()
    Dim epm As New FPMXLClient.EPMAddInAutomation
    Dim client As Object
    'Set client = Application.COMAddIns("FPMXLClient.Connect").Object
    epm.AddMemberToColumnAxis Asset, "000", "CalendarDay", RANGE("W3").VALUE
    End Sub

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 22 at 12:00 PM

    Column Axis already contains members

    using the below code

    epm.AddMemberToColumnAxis Asset, "000", "Calendar Day.Calendar Day", "20 / 1 / 2019"

    I get Error 13 Type Mismatch

    Add comment
    10|10000 characters needed characters exceeded