Skip to Content
avatar image
Former Member

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Nov 04, 2015 at 11:27 PM

    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

    Add comment
    10|10000 characters needed characters exceeded