Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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?

Tags:
Former Member
Former Member replied

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

1 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question