SAP GUI Scripting Tricks, Tips and Basics

I wanted to put a short video together covering the basics and reflect on some of the more frequently asked questions.

All my GUI scripting files on Github (in case you cannot access the above link):

[glinkot]

This was fantastic Csongor. Exactly what I was looking for! I'm going to try and do it with C#, but this answered lots of my questions. I liked the idea of scrolling the window to get all records too - though I might try just hitting 'end' to see if it gets them all that way too. Thanks again

[johnsnodgrass]

Thank you for your selfless contribution!! Very helpful and very much a time-saver for those of us just getting on our feet :)

[amandafernandesramospasson]

again: thank you very this playlist made my work so much easier

[kevinxu]

Thank you for the new post.
Good video for script learning.

[allabout]

Thank You so mutch! This was amazing. I am on way to learn GUI Scripting. For now This was great introduction in topic. Pleas continue explain and educate us in this topic. Waiting for next videos / SAP GUI Scripring and VBA Macros/ Thanks one more time! MY FAVORITE CHANEL :)

[karthikgunda]

Wonderful, thank you very much for making these videos

[prieshvalabh]

Hi Csongor, Thank you for all the useful and helpful scripts/videos you share, I use them in my daily work to develop reports.I thought I  share my  loop where you scroll line by line in the  gridview table, this I have used for SAP GUI Scripting in MS Access:Once you are at your relevant GRIDVIEW table you want to extract  , then below script to follow:' Save the gridview control as a local object
    Set GridView =
   
     If GridView.RowCount >= 1 Then
  Do
   GridView.SelectedRows = CStr(sapRow)
  
   GridView.SetCurrentCell sapRow, "VTGNR"{{{{1st Field of my GRIDVIEW >you need to change to your field name.
   GridView.SetFocus
  
   sapRow = sapRow + 1
   If sapRow >= GridView.RowCount Then Exit Do
   GridView.FirstVisibleRow = sapRow   GridView.SelectedRows = CStr(sapRow)  Loop
End IfI hope this will members who will be interested. Best RegardsPriesh ValabhP.S. Do you perhaps, have any VBA scripts for SAP analysis for office data to be  transferred into MS Access:Much Appreciated.

[jagadeshk]

Hi Csongor,

All the tutorials you explained are awesome. I have gone through all the xlsm files which you shared except this scroll down file. If you share that file too, that will be really helpful.
Thanks and keep up doing this for work.

[kavitadevupalli]

Hello Csongor, thank you for your valuable contribution. Could you please share the above scripting example(Order creation) templet for ref. I couldnt able to find that in your above-shared folder.

[dpworld]

I am getting an error the control could not be found by id while creating PO's by using script in me21n could you please advise me any solution.Thank you so much!!

[mitchfoley]

Hello Csongor,
Thank you for making these helpful videos. I don't currently have access to script recording, but am in the process of gathering information so I can propose the idea to management. Winshuttle is currently used where I work, and I was wondering if you had any idea of how scripting compares to what is offered by Winshuttle. I am under the impression that Winshuttle provides templates for batch processing where as scripting basically allows you to make your own template. Thanks again.

[kalimullah]

Hello sir good day sir my question is How to bulk picking list post and generate many invoices I tried in VL06 mark picking list and selected date then post picking list posted but invoice one ready

[siddheshguravg]

I need help with the right bottom arrow button (status fields).. the details currently shown is the system name... My requirement is to click on it using automation to take screenshot of system, client, user, etc. Any help is appreciated..

[tpdakc]

You can make videos automatically import data from excel to SAP NetWeaver Portal

[ahmed_elalfy]

Hi there Csongor. Brilliant video series on SAP GUI Scripting thanks for that. Have got a problem with Playing back in the recorder. I have recorded the Scripting, and when i tried to play it in the recorder, nothing happened. Or do i need to only playing it back using the code in Excel? Any help with that would be great thank you.

[garycalverley]

Thanks for posting the video's, these are all very helpful. However; I don't find your excel example to download now... has it been removed?

[carlosdelacruz]

Hello Csongor, thank you for putting together these videos. I have a question, can you replace the Id with the IconName? For example, replacing "wnd[0]/usr/txtRF05A-AMPEL" with "S_TL_Y". I'm getting started with SAP scripting and I wonder if there's a way to shorten the lines of code since they are sometimes hard to read with such long Ids. Thank you.

[sandornyemcsok]

Helló Csongor,


a mappa és/vagy filenév kiválasztás egyszerűen megoldható a VBA-ban (van rá parancs, egy sima Windows API hívást generál). Ha érdekel, megmutatom, hogyan lehet használni.

[amitkumaramit]

Is there a way to get the list of SAP GUI connection names in the system using VBA?

[deepakkumar-hsoe]

Hi Csongor
Very informative videos and really you have explained it very well. i have learnt a lot from your videos. keep posting :)
i have a doubt can we take a screenshot in sap not from keyboard but from sap so i can use it in scripting and also can we send that screenshot to a word doc? or save it in my PC as a image or mail it to my Email. i have searched there are some codes on google which do something like this but iam not able to get that code some errors i get. if possible can you post a video which can cover my query.
Thanks a lot for your videos very very helpful.
Please keep posting i have some more doubts but one at a time.