I would record the script that goes to that pop-up window and debug that.

@@csongorvarga thanks csongor. Didn't realized I could do that when logging in. I managed to automate report generation and is looking into python script to run sap GUI script. Thanks again

Oh yes, I must have forgotten it. Link is added now.

You mean connecting to different SAP systems? Yes of course. You probably need to create different objects for each session, but there is no reason it would not work.

Thanks. I never used Winshuttle but I think it also uses scripting and builds an environment around it so you do not have to do any coding at all. Create a recording, Winshuttle identifies the variables in the recording, puts them into Excel and loops the script over and over with the data you maintain in Excel.

Thanks. Interesting issue. I have never tried this before. I have found a few examples in which you simply send the PrintScreen key combination from Excel which triggers Window Screen Capture and just paste it into your Excel document. I assume the same can be done with Word as well: stackoverflow.com/questions/43904385/using-excel-vba-macro-to-capture-save-screenshot-of-specific-area-in-same-file

@@csongorvarga Hi Csongor Writing again 😊 also want to thanks for your videos very helpful. Coming to point. Need a small help from you. Can you provide me your email address or just ping me on dkdeepak45@gmail.com so I can take help from you via mail. Thanks in advance session.findById("wnd[0]").maximize session.findById("wnd[0]/tbar[0]/okcd").text = "/nsmlg" session.findById("wnd[0]").sendVKey 0 session.findById("wnd[0]/mbar/menu[2]/menu[0]").select session.findById("wnd[0]/tbar[0]/btn[71]").press session.findById("wnd[1]/usr/txtRSYSF-STRING").text = "number of users" session.findById("wnd[1]").sendVKey 0 session.findById("wnd[2]/usr/lbl[18,2]").setFocus session.findById("wnd[2]/usr/lbl[18,2]").caretPosition = 8 session.findById("wnd[2]").sendVKey 2 session.findById("wnd[0]/usr/lbl[18,7]").caretPosition = 7 session.findById("wnd[0]").sendVKey 0 This is a code in which I want to get the number of users from the smlg tcode and to Excel I want to save that so . My question is I am changing caretposition by text then it gives error in the code can you please shed some light on this. Again thanks in advance

No, the ID is the ID of the screen element. That is controlled by SAP, so it has to stay like that. S_TL_Y is SAP's ID for the amber icon. Most probably that is the icon's internal technical ID. We have to use it like that.

Thank for getting back to me. Once again, thank you for putting together these helpful videos.

To be honest, I was 5-6 years ago when I started to work on this, when the SAP GUI was older version and direct Excel export never worked reliably for me. But it may be easier to do nowadays.

No, the playback from the GUI tools should be working all the time. I can't tell why this is not working for you.

Didn't you watch this video? Everything you need is explained here.

Where does it says that "scripting is not installed"? You may have to talk to your basis people about that.

If only script recording is disabled, you can play the script. That is two different system settings. If you cannot play a script, probably the entire scripting is disabled.

Record with a script. It is just setting the field value to the code behind the dropdown value.

@@csongorvarga the recorded script part for this step is "...Key. = "B9" Where B9 is the output of the drop-down list which I want to use, but the macro doesn't recognize it. It just ends without any error.

Uh, I have not experinced it myself. Could be new basis/security settings in RZ11 which disabled script playback?

You can put a breakpoint in the code in Excel document where you pasted in the recorded script. The execution will stop at that point, you can put variable into the watch window. I don't think you can debug outside Excel.

Sorry, I have no idea how to get that. I don't think that is something that would be stored in a table. But if you get the object /app/con[0]/ses[1]/wnd[0]/usr/ you can go through it's child items in the code one-by-one. And you can get the information that way.

@@csongorvarga Ok thanks. It will work out that way.

I don't know, never heard of virtual key. But why do you want to send a down arrow key?

@@csongorvarga I wanted to download a series of files from SAP directory so putting in a loop and moving down to next files requires that key so I asked. Anyways thanks for the reply

@@chijinkumar7995 OK, I understand. The list which contains your files, probably has some different ID. So it would be possible to highlight each line using scripting and not rely on the down arrow keypress.

Yes you can do that in variants. Save a variant, and when you are in the variant screen, find your date field in the list, go to the Selection variable field, and pick "D", and in the Name of the Variable, you can select "current date +/- ??? work days. Set Include and the operator for that option. When you click OK on that screen you can enter the day value with sign, for example -1 and the factory calendar based on which the work days will be calculated.

@@csongorvarga Thank You so much 🙏

Sorry, what do you mean the video is not available? I did not put any restriction to the video, it should be available everywhere, unless Google has other ideas.

If the playback is disabled, no. If only the recording is disabled it is possible to play.

@@csongorvarga Script recording and playbck is grey out.

I think you are looking for this: kzfaq.info/get/bejne/pbaAm6RimbbRXWw.html. I am at 7.6 at the moment. I did not use scripting recently, but I am sure I used it on 7.4 in the past. What is your issue?

@@csongorvarga Somehow my Excel scripting can't seem to connect with the SAP Gui 7.4 and then select needs yo find the correct SID and Instance number. It should be PRD500 but in the properties I see System ID = PRD and Instance number = 54. I have tried both but I get every time an error: "No active session to system PRD500, or scripting is not enabled. Then the scripting stops at " Set objSbar = objSess.FindById("wnd[0]/sbar")" Btw I doesn't have access to RZ11. I have requested that and I hope I get it!!!

@@marcelknegt6521 Well, first of all in your SAP gui, select Customize Local Layout button, and pick Script Recording and Playback from the menu. If the play button is disabled there, scripting is disabled in PRD 500. So you need to enable it (get RZ11 access or get basis to do it).

Thanks. There is a link in each video description. I have a separate video on BDN Download.

In my examples, I either have a reference to the system in the VB code, or a cell in the worksheet. You just change that and the script connects to your PRD system.

@@csongorvarga Thanks a lot, but the PRD System not recognise the transaction ID.

I don't think there is a free open system and there is certainly no version that you can download. Open.sap.com has a lot of free courses (mostly high level), maybe some will allow to create a test account to a cloud version to try.

Go into the GUI Options and there you can turn off notification when scripting starts.

I don't have access to SAP right now. But you can use a for loop, and use the loop variable as part of the statement like session.findById("wnd[0]/usr/tblSAPLKOBSTC_RULES/txtCOBRB-GBISP[" + i + ",0]").Text

@@csongorvarga Very thanks for your reply!!! It really solved my problem :)

I did one video how you can use Access with GUI scripting: kzfaq.info/get/bejne/prFxjdSExNqpmmg.html

@@csongorvarga I couldn't set grid view

@@csongorvarga It is throwing an error that control could not be found by id

@@dasarigayatri9278 The example is specific to the screen I designed it for. You need to create your own recording for your own transaction and adjust the VB code.

Oh yes sure. You can use findbyid and put the result into an variable (type Object) and later reference to that as variable.property.