cancel
Showing results for 
Search instead for 
Did you mean: 

Run time error '424' Object Required EPM VBA

Former Member
0 Kudos

Hello Masters,

I am trying to automate a EPM report through VBA and came to an halt.

I am trying to retrieve report name of the active sheet below is my code.

dim EPMOBJ as EPMADDINAUTOMATION

EPMONJ.createreport sheetname,connection name ,"reportname1" and so on.

I get the error on a = EPMOBJ.getactivereportname(activesheet.name)

it says object required.

I am able to create report successfully but after that need to add more columns into the report.

can some one help!

examples are appreciated. (sorry for not tagging the code as I don't know how).

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Try Using this at the start

Option Explicit

Dim EPMOBJ As New FPMXLClient.EPMAddInAutomation

instead of dim EPMOBJ as EPMADDINAUTOMATION

Make Sure FPXMLClient is checked in tools-> references

Thanks,

Varsha

Former Member
0 Kudos

sorry for the late response but that didn't helped me it still gives me the same error... I want to add more members into the row instead of one.

but on this line it gives error object required but I have already declared variables.

EPMOBJ.addmemberstocolumnaxis

any help will really be appreciated..

Former Member
0 Kudos

please ignore the earlier post I got it working.. 🙂

Answers (0)