Select an item by name instead of id in VBS

Question

I have recorded a script on SAP that runs on CITRIX. Everything worked fine until some items were added to the window that the right item was selected to filter the columns. I guess the reason is that the proper item (e.g. MATART in the shown picture) moved down and it was not the same row, order etc.

I was wondering whether there is a way to select the item by its name instead of id?

This is the part of the script with the line which selects the items:

session.findById("wnd[0]/tbar[0]/okcd").text = "/nzm082"
session.findById("wnd[0]").sendVKey 0
session.findById("wnd[0]/tbar[1]/btn[8]").press
session.findById("wnd[0]/tbar[1]/btn[33]").press
session.findById("wnd[1]/usr/cntlGRID/shellcont/shell").currentCellRow = 1
session.findById("wnd[1]/usr/cntlGRID/shellcont/shell").selectedRows = "1"
session.findById("wnd[1]/usr/cntlGRID/shellcont/shell").clickCurrentCell
session.findById("wnd[0]/tbar[1]/btn[45]").press

ScriptMan · Accepted Answer · 2019-03-13T19:02:25.417

You could test the following.

for example:

...
session.findById("wnd[0]/tbar[1]/btn[33]").press
set myLayout = session.findById("wnd[1]/usr/cntlGRID/shellcont/shell")

Rows = myLayout.RowCount
For i = 0 to Rows - 1 
myVariant = session.findById("wnd[1]/usr/cntlGRID/shellcont/shell").getCellValue (i, "VARIANT")
if myVariant = "MTART" then
   session.findById("wnd[1]/usr/cntlGRID/shellcont/shell").currentCellRow = i
   session.findById("wnd[1]/usr/cntlGRID/shellcont/shell").clickCurrentCell
   Exit For
end if
next
session.findById("wnd[0]/tbar[1]/btn[45]").press
...

Regards, ScriptMan

Select an item by name instead of id in VBS

1 Answers1