Showing results for 
Search instead for 
Did you mean: 

How to create a custom button in Excel while log on to BI through BEx

Former Member
0 Kudos

Hi all,

I have an requirement to add a button in excel application, while we log on to BI

through BEx.

I know only that it has to be done with macros. I dont have any idea in this.

When i click on that button an RFC should get executed.

Pls help in this, I am not able to move anymore.


Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Got the solution.

Closing the thread.

Former Member
0 Kudos


You can try report to report interface, to allow you to jump from one report into a SAP transcation.

for macro's reference and procedure:



Former Member
0 Kudos

Thanks a lot for your rply.

I dont want to go for Report to Report Interface, as i dont want to get data from any other SAP system.

What i want to do is,

While we logon to BI using BEx analyser, in the excel interface I want to provide a feature to create a

support desk message if the user is facing any issues.

Support desk message has to be created in SAP Solution manager system.

So in excel interface by clicking a custom button a RFC logon to the SAP Solution manager system

has to be created and a ticket has to be created in the same.

Pls provide some inputs regarding calling RFC's using VB Script in Macro.