error with MNU_eDATA_SELECTPACKAGE

[former_member200537]

Hi,

we are tyring to embeed Datamanger to a excel button using macro with MNU_eDATA_SELECTPACKAGE function.

we created this button and assigned to it a VBA Macro with the following code in excel workbook:

Application.Run "MNU_eDATA_SELECTPACKAGE", "Historical", "ZBPC_RUN_ALLOC2", "Company", "Financial Processes"

and it is working fine.Problem is some times after reopening workbook and clicking on button it is giving "Run-time error '1004' The macro 'MNU_eDATA_SELECTPACKAGE' cannot be found error message.

Note: the issue is not consistent meaning it is throwing error message some times but not every time.

Please suggest us on this issue.

Thanks

UDAY

[former_member200537]

i called edata menu by using Application.Rn "MNU_EDATA" macro

[Former Member]

Hi Udaya,

The main problem here is that this particular MNU command will work perfectly if you open the eData menu once in the BPC excel session. If that is not opened, you will get this error sometimes. So, as suggested, you can have

Application.Run "MNU_eTOOLS_DATAMANAGER"

Application.Run "MNU_eDATA_SELECTPACKAGE", "Historical", "ZBPC_RUN_ALLOC2", "Company", "Financial Processes"

Try it and let us know if it works or not.

Hope this helps.

[Former Member]

Hi,

As suggested by Anurodh that should be the issue. Please check you have assigned the macro correctly for the button in the sheet where the macro is written.

Regards,

G.Vijaya Kumar

[former_member200537]

Hi,

I'm using single worksheet only in excel workbook.when i reopen the workbook and click on the button some times it is running datamanager and sometimes it is throwing error message with same vb code (with out any change).

Any more suggestions.

[Former Member]

what could i analyze is :

there can be more than one worksheet where u had used the same macro in other sheet also.

And the reference of taht macro linked with another.

So if you close original sheet, the other sheet could not able to find the macro.

[radharamansingh_rajkumar]

Hi,

you can use this way

Application.Run "MNU_eTOOLS_DATAMANAGER"

Application.Run "MNU_eDATA_SELECTPACKAGE", "Historical", "ZBPC_RUN_ALLOC2", "Company", "Financial Processes"

Regards

Raman