SAP GUI Scripting 1 - Running scripts from Excel 

why is sap so complicated ?

@@trimerista So it can keep all the SAP consultants with jobs :)

@@csongorvarga hahaha

Thanks for this comment :)

Hello.. Can u please tell me how to write that language format.. I want to make a script to run on SAP.. Pls ans me.. It would be appreciated

Thanks man!

Thanks a lot mate!

I am glad you find it useful.

You are welcome

Thanks a lot! Happy scripting!

Can I automate SAP GUI without RZ11 authorization?

Power Automate and Power BI is a good combination. I did not think about that!

Orulok hogy segitett. Ez a slager temaja a csatornamnak, annak ellenere hogy ez csak 5-6 video.

You are welcome

I am glad to hear that. I started this whole journey for the very same reason (automate testing).

Hi Varga, I've just 1 question. I am able to log in in SAP using different users, though logging off is really difficult. Do you know the VBA code to log off from SAP?

The connection object (objConn) has a CloseConnection method. Try that. It also has a CloseSession method, but for that you need to provide the session id. So close connection could be easier if works. Sorry I don't have time to try them out myself.

@Csongor Varga how are you able to connect to SAP without loading the .dll's that are required for Excel to speak to SAP?

what happen if i keep SAPFEWSE.OCX file in D:\ folder,, is it mandatory to keep in c:\program files..........

You are welcome!

If you don't mind can I ask a question, for some changes we do in SAP there will be pop up window how do I read it in macro and press enter only when there is window popped up.

+Satish Kumar I have covered this in another episode in my channel. Before the line for the pop-up window add "on error resume next" that will ignore any errors and continue the next line in the code.

You are welcome!

Thanks. Check this thread out. There are a few examples how to take a screenshot from VBA: stackoverflow.com/questions/43904385/using-excel-vba-macro-to-capture-save-screenshot-of-specific-area-in-same-file. As far as I can see there some examples how to save the image in to a jpeg (otherwise it is only pasted into the Excel document). Having a quick look in the Object Browser it seems Application.ActiveWindow.WindowState = xlMinimized can be used to minimize the Excel once the script starts running so the screenshot is taken from your SAP GUI screen. Just make sure that SAP GUI is under Excel not something else. I think that could work.

The recorder created a vbs file. I just open that with Notepad and that's it.

Thanks a lot man!

I have not tried that. I did download from SAP in SE16 which worked, so I have no reason to say that SAP did not build some support for upload.

Yes, you can create a recording doing the copy paste. The system will record as the first field gets focus. It will be a ...SetFocus line. You replace the SetFocus property with Text and save the value into a local variable. And on the target field you put that value in.

Wow! thanks for the quick response. Thanks again :)

Thanks. I only have scripts which was shown here on RU-vid. No other cases at the moment.

Suhail Surve uh, I don't remember from the top of my head (I am away from the computer), but it is the sapfewse.ocx which should be somewhere in the sap gui folder.

Good to know. I usually running modest scripts, so speed is not an issue for me. And I like to see it running.

Thanks. Well, I am not sure what the reason can be. You can always debug the code and run the scripting part step by step. That way you see which lines are executed and where the script stops. It is possible that there is a pop-up message which will block the script from running the next line. You can also comment out the "On Error Resume Next" line and your script will stop where the issue is. Warning messages, confirmation pop-up messages could be causing the script to fail in certain cases.

If you get the transport number as part the message on the status bar, you can get it with ...FindById("wnd[0]/sbar").Text. Otherwise create a new recording in which you select field where the transport number is displayed. That will be part of the recording as something.Selected or similar. That tells you how to get that field and it probably has a Value or Text property which give you the actual value. For example in another video, I used the following line to get the order number from the status bar. I used the Mid function to slide the number out of the message text: Cells(5, 5).Value = Mid(objSess.FindById("wnd[0]/sbar").Text, 16, 10)

Yes, this is now I designed the code. The intention was that script connects to the session which runs the transaction in case you are logged into the same client in multiple sessions. Look for this in the code: "And W_Sess.Info.Transaction = tcode" and remove from the line.

+Csongor Varga Thank you for the reply. I have removed that line (tcode) from script. Is there a was if the first session is running a tcode, can the script open a new session and run VBA code?

Do not remove the entire line, just what I quoted. I have not tried running two scripts at the same time. You need to check that.

yes Varga, i dint remove the entire line. i removed only the one which you have quoted. by the way Thank you for your support . Appreciated.

+michael Angelou Megio well, just check if the cell has a value and execute that field update within the if statement. SAP would not mind if you don't execute one line. So If Cells(x,y).Value"" Then objses.... End If

Yes that is correct. But I seem to have run the same Excel multiple times, and it does not make a difference if the session is already connected or not.

Yes, in my code I create a variable for a session and connect to a gui session based on the sid and client id. You can create another session variable and connect to another session in the same system or even different system. I have never done an example like that, but I see no reason why it would not work.

The script takes the SID and client form a cell on the sheet. So you just need to change that to your test client... I am not sure why it is not working.

Sure, first name dot last name on gmail.