topic Re: SAP Script via VBA in Application Development and Automation Discussions

SAP Script via VBA

former_member1200558 — Wed, 18 Aug 2021 15:21:15 GMT

I am automating a SAP screen that has a grid and I need to check a value in the grid. But the problem is the grid changes dynamically.

Set GRID1 = session.findById("wnd[0]/usr/cntlOBJ_LOG_CONTAINER/shellcont/shell/shellcont[4]/shell")

shellcont[4] changes dynamically

Please give some insights

Re: SAP Script via VBA

former_member751591 — Wed, 18 Aug 2021 15:24:11 GMT

Welcome to the SAP Community! Take these tutorials to learn more about getting started:

Ask and Answer Questions on SAP Community | Tutorials for SAP Developers

Update and Maintain Your SAP Profile at people.sap.com | Tutorials for SAP Developers

Tour the SAP Community | Tutorials for SAP Developers

Thank you!

Re: SAP Script via VBA

Sandra_Rossi — Wed, 18 Aug 2021 19:33:09 GMT

You are the only one to know what the screen looks like, so people can't help you much. I guess you have several possible containers, and you want to find the one which contains a GuiGridView object. Do other ones contain GuiGridView objects too? If yes, how do you distinguish them?

Maybe this blog post can be sufficient: https://blogs.sap.com/2021/06/28/how-to-detect-ui-element-id-with-regular-expressions-in-sap-gui-scripting/

Re: SAP Script via VBA

former_member1200558 — Tue, 24 Aug 2021 06:06:19 GMT

Thanks for the response Sandra. I have attached the screenshot of the control that I am trying to automate. This control has the id session.findById("wnd[0]/usr/cntlOBJ_LOG_CONTAINER/shellcont/shell/shellcont[4]/shell") in which shellcont[4] changes dynamically (4 is changed dynamically as 3/2)