on 04-29-2016 1:14 PM
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).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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..
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.