topic Excel & SAP in Application Development and Automation Discussions

Excel & SAP

Former Member — Fri, 06 Jul 2007 05:01:08 GMT

Hello all,

I had arquirement as follows.

I had one push button in an excel, when i click that the sap logon screen must come.

How to do this please help. Urgent.

I will reward all usefull answers.

Rakesh.

Re: Excel & SAP

Former Member — Fri, 06 Jul 2007 05:05:25 GMT

Hi Rakesh,

May be you have to use some Micros in Excel.

Reward if useful!

Re: Excel & SAP

Former Member — Fri, 06 Jul 2007 05:07:36 GMT

Hello prasad,

I have no idea of that,

Could you please make it clear.

Rakesh

Re: Excel & SAP

Former Member — Fri, 06 Jul 2007 05:16:15 GMT

good

you need to know VB for this functionality,there is a Call function in VB which is generally use to call any other functionality.

thanks

mrutyun^

Re: Excel & SAP

Former Member — Fri, 06 Jul 2007 06:06:39 GMT

Hi Rakesh,

We need to use macros in excel ,

You can do it as mentioned below,

1. First create a short cut of the program in SAP , this can be done by selecting the Customizing of local layout button in the standard toolbar. ( Alt + F12). Save the shortcut of the desired program in the desktop.

2. Create a pushbutton in the excel sheet , can be done by pressing forms button , or right click the toolbar and select Forms.

3. Put a sample text,

For Eg : TEST , right click this text and attach a hyperlink so that to select the short cut file which we created in the 1st step.

4. Now Record a macro in excel, for eg : MACRO1.

It can be done by TOOLS-> Macro -> Record new macro .

Now click the hyperlink text 'TEST' so that the shortcut file will be opened, after giving login name and password. Now stop recording. TOOLS-> Macro -> Stop recording.

5. Right click the push button and assign the macro MACRO1 to push button.

SAVE.

6. ( OPTIONAL ) Hide the field 'TEST' .

7. Save the excel file. Now it is ready .

Thanks & Regards,

Kamani

Re: Excel & SAP

Former Member — Fri, 06 Jul 2007 06:11:45 GMT

Hi Rakesh,

Micro is itself is a big topic.

Please go through below link:

http://www.codeguru.com/vb/gen/vb_misc/article.php/c5595/

Reward if useful!

Re: Excel & SAP

Former Member — Fri, 06 Jul 2007 06:13:59 GMT

Hi,

Adding to above lines:

While calling to Logon screen , you have to also take care of connections to be made. As it can be a secured login etc.

Please find if you can get any business connector or check in BW , BEX analyser.

Reward if useful!