VBScript and concatenation of variable

Question

I do not want to use arrays but want to concanate variable in order to devide some variables with one loop for example something like this:

Dim varr1,varr2,varr3,varr4,i
i=1
varr1=2
varr2=5
varr3=8
varr4=9
Do While i < 5
  varr&i = (varr&i)/2
  i = i + 1
Loop

Could this be done in any way?

Even if it can be done: don't. It's a terrible practice with no redeeming qualities. Use an array or a dictionary instead. DO NOT construct variable names dynamically. EVER. — Ansgar Wiechers
– Ansgar Wiechers, Commented Aug 17, 2017 at 22:26

Gurmanjot Singh · Accepted Answer · 2017-08-17 17:23:25Z

0

We can use the Execute command to get what you need.

Dim varr1,varr2,varr3,varr4,i
i=1
varr1=2
varr2=5
varr3=8
varr4=9
Do While i < 5
  Execute "varr"&i&" = (varr"&i&")/2"
  'Execute "MsgBox varr"&i                                'un-comment this line to see the desired output
  i = i + 1
Loop

answered Aug 17, 2017 at 17:23

Gurmanjot Singh

10.4k2 gold badges22 silver badges46 bronze badges

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

Comments

0liveradam8 · Accepted Answer · 2017-08-17 16:39:09Z

0

Dim concat
concat = varr1&varr2&varr3&varr4

You cannot automatically iterate through each of these variables unless you store them in an array.

answered Aug 17, 2017 at 16:39

0liveradam8

7784 silver badges18 bronze badges

1 Comment

Gurmanjot Singh Over a year ago

We can do it using Execute statement.

Collectives™ on Stack Overflow

VBScript and concatenation of variable

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related