How to Open a Specific Template with VBA or EVMNU in SAP BPC 7.5 NW

[Former Member]

Hi Expert!

I am currently working with SAP BPC 7.5 making some improvements, they have their BPF through Excel and with the help of macros and EVMD function, I'm trying to open a specified template and I'm using the following sintaxys:=EVMNU("MNU_eSUBMIT_OPENSTANDARD";;"Input Schedules/MARCO FISCAL/IN06_Base Proyeccion Ingresos.xlsm")  the problem is that if I put the parameter with the full path and name of the template by double clicking on this I do not open the template I only activates the cell to change the function from excel, if only I place the name of the macro "MNU_eSUBMIT_OPENSTANDARD "if I open the folder Input shedules

Please I need know if not is posiible call a specific template with this command, If not is possible, someone have an idea of how i call it?

[former_member223971 · Accepted solution]

Hi Natalia

Please, validate the next note:

Symptom

User is not able to open a file using the fonction EVMNU:

Example: =EVMNU("OPENFILE";"inputfile";"INPUT SCHEDULES\inputfile.xlt")

Environment

BPC 7.5 NW SPx

Cause

The function EVMNU read from the folder Wizard.

Resolution

The template should be saved under the folder wizard.

Example: =EVMNU("OPENFILE";"inputfile";"INPUT SCHEDULES\Wizard\inputfile.xlt")

The sample MNU_eSUBMIT_OPENSTANDARD and MNU_eANALYZE_OPENSTANDARD formulas should not contain a third parameter.

Best Regards

Juan Pablo

[Former Member · Accepted solution]

Hi Juan Pablo,

In effect the that you said is true, the unique inconveniente is that I can't use the groups folders , because this function only open from if the template is inside of local folder in the Wizard route.

Thank you so much for your answer.. My dear boyfriend

[former_member186338 · Accepted solution]

Just some comments!

With EVMNU OPENFILE I am able to open file located:

HTTP://BPCSERVERNAME/APPSETNAME/APPNAME/eEXCEL/REPORTS/SIM_by_Entity1.xls

With the formula:

=EVMNU("OPENFILE";"ScreenName";"/Reports/SIM_by_Entity1.xls")

Not from the WIZARD folder

Vadim

[Former Member · Accepted solution]

Hi Vadim..!

You're absolutely right, thank you very much for your comment.

Natalia.