Analysis for Office Open Workbook from Toolbar, instead of Filemenu of Excel

[MK90]

Hi all,

i wanted to ask you, if it is possible to get the functionality of opening an Analysis for Office Workbook from the Analysis Tab (Menu Bar), where you also open DataSources.

I wanted to leverage the UI customizer to use the exact button functionality from the File Menu Analysis > Open Workbook > From SAP Netweaver Server.

This functionality must have a Macro or function behind. But unluckily i am not able to open/display the function as in other functions of the UI customizer. (e.g. something like "Open_Workbook" - but the exact function is yet unknown to me).

I would be happy to receive some help or where i can find some specifics in the code (xml) of Analysis for Office, where these functions are realized.

[harsha_jalakam]

Hi , were you able to achieve this? I would like to achieve the same(open workbook pop up) through a custom button in the ribbon and not sure which macro is associated with this?

Thanks in advance.

Regards,
Harsha