Concatenating a string and numeric variable

Question

I need some help here, I have a command for SAP GUI script in VBA where I just need to change a number am each line, is there a way to have just one line and create a loop? num1 = 5, num2 = 9, num3 = 10

session.findById("wnd[1]/usr/chk[2,5]").Selected = True
session.findById("wnd[1]/usr/chk[2,9]").Selected = True
session.findById("wnd[1]/usr/chk[2,10]").Selected = True

what I hope

session.findById("wnd[1]/usr/chk[2,numX]").Selected = True

The question is only about concatenating string and numeric variable, it's not specific to SAP GUI. I have changed the title and tags accordingly. — Sandra Rossi
– Sandra Rossi, Commented Aug 3, 2022 at 18:05

Darren Bartrup-Cook · Accepted Answer · 2022-08-03 13:58:17Z

2

Another way using a For Each loop.

Sub Test()

    Dim vNums() As Variant
    vNums = Array(5, 9, 10)
    
    Dim vNum As Variant
    For Each vNum In vNums
        session.findById("wnd[1]/usr/chk[2," & vNum & "]").Selected = True
    Next vNum
    
End Sub

answered Aug 3, 2022 at 13:58

Darren Bartrup-Cook

20.2k2 gold badges27 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ScriptMan · Accepted Answer · 2022-08-03 13:34:27Z

0

for example:

For numx = 5 To 13 Step 4
    If numx = 13 Then numx = 10
    session.findById("wnd[1]/usr/chk[2," & cstr(numx) & "]").Selected = True
next

Regards, ScriptMan

answered Aug 3, 2022 at 13:34

ScriptMan

1,6351 gold badge10 silver badges9 bronze badges

Collectives™ on Stack Overflow

Concatenating a string and numeric variable

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related