How to Open a Specific Template with VBA or EVMNU in SAP BPC 7.5 NW
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?
Please, validate the next note:
User is not able to open a file using the fonction EVMNU:
Example: =EVMNU("OPENFILE";"inputfile";"INPUT SCHEDULES\inputfile.xlt")
BPC 7.5 NW SPx
The function EVMNU read from the folder Wizard.
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.